Test your skills: Querying MongoDB with SQL

You create a SELECT statement in SQL Query that retrieves data from the customers collection. After you run the statement, you view the mongo shell find statement that was generated for the SQL SELECT statement.

Which SELECT statement clause maps to the projection section in the find statement?

You launch SQL Query and create the following SQL statement, which retrieves data from the customers collection:

select first, last, transactions
from customers
where address.state = 'Oregon'
order by transactions desc;

After you run the SQL statement, you view the mongo shell find statement on the Query Code tab. Which expression appears in the sort section of the find statement?

You are building an SQL statement in SQL Query that retrieves data from the customers collection. You want to limit the results to customers born before the year 1980, based on the values in the dob field.

Which clause should you include in your statement:

You launch SQL Query and create the following SQL statement, which retrieves data from the customers collection:

select first, last
from customers
where interests like '%gaming%'
order by last, first;

After you run the SQL statement, you view the mongo shell find statement on the Query Code tab. Which expression appears in the query section of the find statement?

You launch SQL Query and create the following SQL statement, which retrieves data from the customers collection:

select address.state, sum(transactions) 
from customers
group by address.state
order by sum(transactions) desc;

After you run the SQL statement, you go to the Query Code tab. What type of mongo shell statement has SQL Query created?

You launch SQL Query and create an SQL statement that retrieves data from the customers collection. After you run the statement, you go to the Query Code tab to view the mongo shell aggregate statement.

You now want to edit the statement in the Aggregation Editor. Which step should you take?