Using GardenCompany$09$ access database:

$1-15pts$

Write the query that display for each orderid the number line into the order details. $($use group by$)$

$\backslash$table$[[$orderid$,$lines$],[11079,],[11080,2],[11081,2],[11082,1],[11083,4],[11084,2]]$

$2-15$ pts

Adjust the query to display only the order having number of lines $3.($use group by and having$)$

$3-15pts$

Find the productId and the unitprice for all the products

$4-15pts$

Find all the products having orders. $($use inner join and the IN operators$)$

$5-15pts$

Find all the products involved in at least $4$ orders. $.($use inner join and the IN operators$)$