Question #35975
1) Fetch all the customers that are not from region 'BC' or 'SP'
2 Show all customer contact names and titles for the business owners who are from Germany or France
3 Fetch customers from Germany, Mexico and Sweden
4 Display customers that are from Switzerland but not from city Bern
5 Display total amount by Order ID
6 Count the number of products by Category ID
7 Count the number of products by Category ID and Discontinued status
8 Count the number of products by Supplier ID and Category ID
9 Count the number of products that need to be re-ordered
10 Count the number of products by category ID that are sold in bottles
2 Show all customer contact names and titles for the business owners who are from Germany or France
3 Fetch customers from Germany, Mexico and Sweden
4 Display customers that are from Switzerland but not from city Bern
5 Display total amount by Order ID
6 Count the number of products by Category ID
7 Count the number of products by Category ID and Discontinued status
8 Count the number of products by Supplier ID and Category ID
9 Count the number of products that need to be re-ordered
10 Count the number of products by category ID that are sold in bottles
Expert's answer
Unfortunately, your question requires a lot of work and cannot be done for free. Please submit it with all requirements as an assignment to our control panel and we'll assist you.
Comments