How to use the 'as' keyword to alias a table in Oracle?
Solution 1:
You can use AS for table aliasing on many SQL servers (at least MsSQL, MySQL, PostrgreSQL) but it's always optional and on Oracle it's illegal.
So remove the AS :
SELECT G.Guest_ID, G.First_Name, G.Last_Name
FROM Guest G