You can just give me the commends, I have access to the database and can plug in... Thanks Using the SELECT statement, q

[answerhappygod]

You can just give me the commends, I have access to
the database and can plug in... Thanks
Using the SELECT statement, query the track table to
find the average length of a track that has the genre_id not equal
to 1.
Using the SELECT statement, query the invoice table to
find the average total cost for all orders purchased in the country
USA rounded to the nearest cent.
Using the GROUP BY clause and the count aggregate function,
filter the customer table grouped based on country.
How many customers are in France?
Using the GROUP BY and HAVING clause, filter the track table by
album_id.
How many groups have more than 25 tracks?
Using the WHERE and HAVING clauses, filter the invoice table to
include the billing_country as either the USA, France, or Canada.
Group the invoices by country, having the number of orders greater
than 40. Provide the list of countries and their counts that fit
these criteria.
Which of the following queries would provide the correct
results?
FROM invoice
WHERE billing_country in ('France','USA','Canada')
GROUP BY billing_country
HAVING count(*) > 40
FROM invoice
WHERE count(*) > 40
GROUP BY billing_country
HAVING billing_country in ('France','USA','Canada')
FROM invoice
GROUP BY billing_country
WHERE billing_country in ('France','USA','Canada')
HAVING count(*) > 40
FROM invoice
WHERE billing_country in ('France','USA','Canada')
GROUP BY billing_country
HAVING sum(*) > 40