Write the SQL code to generate the total hours worked and the total charges made by all employees. The results are shown in Figure.
Answer to relevant QuestionsWrite the SQL code to generate the total hours worked and the total charges made to all projects. The results should be the same as those shown in Figure. Use a query to compute the average purchase amount per product made by each customer.Write a query to display the largest average product price of any brand.Write a query to display the brand ID, brand name, and average price of products of each brand. Sort the output by brand name. (Results are shown with the average price rounded to two decimalplaces.)Explain the difference between a regular subquery and a correlated subquery.
Post your question