Advanced Aggregates Ex 1 Step 2:


#1

1.
Complete each query by replacing the comments /**/ with SQL code.

We'll start by looking at SpeedySpoon's data. The orders table has a row for each order of a SpeedySpoon delivery. It says when the order took place, and who ordered it.

Add code to the select statement to select all columns in the orders table.

For the first step the code looks like this:

select *
from /**/
order by id
limit 100;

2.
The order_items table lists the individual foods and their prices in each order.

Complete the query to select all columns in the order_items table.

The provided code looks exactly the same:

select *
from /**/
order by id
limit 100;

Please, help! I'm not sure what it is asking me. :confused:


#2

Complier is asking to replace comment with table_name

select *
from orders
order by id
limit 100;