🎉Great job! Query executed successfully!
Database & Tables
Table Output
Click the RUN button to execute your query and see the results here.
Question 1
Above is a database called restaurant, containing 3 tables (menu, orders & customers). Can you read or extract all the columns from menu table?
Task:
Step 1: Meet your first SQL (Structured Query Language) command — the SELECT statement. It's used to read data from tables in a database.
Step 2: Remember below syntax (Dont forget semicolon at the end)
SELECT which_column FROM which_table;
SELECT which_column FROM which_table;
Step 3: Since we need to see all columns, hence replace which_column with *
Step 4: From which table? Hence, which_table → menu
Step 5: Final query becomes SELECT * FROM menu;
Step 6: Type the above query in the Query Editor on the right and click RUN
Step 7: Observe how the table(columns & rows) looks like in the Table Output
Query Editor