Each task describes a result. Write a query that returns exactly those rows and columns. Look at the table tabs for column names and values.
- Every column of the customers from the United States. Their country code is
US. - Think before you run it: how many rows does
SELECT * FROM customers WHERE country = 'us';return? - The products that cost exactly 6.00:
name, thenprice. - The pending orders:
id, thencustomer_id. - The names of the customers who are members.