Please complete the following $13$ queries and answer all the required questions on LA$2-$Query: You may

find the first $13$ queries $($or similar$)$ in our SQL Lab Tutorial.

Write a query to show first names and last names of employees from the Employees table in the

database. After you run your query, how many records do you get?

Write a query to pull all of the attributes from the Employees table. After you run your query, how

many attributes do you get?

Write a query to show CustomerName and ContactName in the city of London from the Customers

table. After you run your query, how many records do you get?

Write a query to find the average price for each supplier from the Products table. What is the

highest average price in your result $($round to two decimal places as needed$)?$

Write a query to find the number of suppliers with an average price greater than $$28$ in the

Products table. How many suppliers in your result table?

Write a query to find the suppliers with an average price greater than $$25$ with supplierIDs greater

than $5_{?}($Sort SupplierIDs in ascending order$).$ Run your query and answer the following questions:

a$.$ How many records do you get?

b$.$ What is the average price of the first record in your result $($round to two decimal places as

needed$)?$

Write a query to pull all the attributes of the product with product ID greater than $6_{?},$ categoryID

equal to $5,$ and price greater than $8_{?}$ from the Products table. Run your query and answer the

following questions:

a$.$ How many records do you get?

b$.$ Which product has the highest price in your result table? Type the product ID here.

Write a query to show SupplierID and SupplierName of suppliers with $1)$ SupplierID greater than $2$

but smaller than $10$ or $2)$ country equal to USA $[$Use WHERE OR$].$ Please indicate the number of