or this assignment you must use si schema 1. Show the total allowance amount, the average allowance amount, as well as the number cars traded in during the year of 2018 for Mercedes, Acura, Land Rover and Jaguar makes. Note: The allowance for each car that is traded in is stored in tradeallow of the tradeiny table. (5 marks). 2. The salespeople performances are evaluated based on the number of cars they have sold. Their performance is classified as: Low - if they have sold less than 20 cars Medium - if they have sold between 20 and 30 cars High - if they have sold more than 30 cars Show the names of the salespeople (job title - salesman) and their level of performance. (5 marks) 3. Using SET operation show the names and home phone numbers of the customers, who own cars of make Land Rover, and they have never brought their cars in for service. (5 marks) 4. Show the total amount of money that customers from the province of Alberta (AB) have spent on labor when servicing their cars. Show the subtotals for each city from that provice (5 marks) 5. Using analytic functions display the highest and the lowest carsaleprice for each car make and rank them based on the highest price in descending order. (5 marks) 6. Using analytic functions return the name of the customer who bought the third most expensive car. (5 marks) 7. For each customer from London, return the price of the car they bought and the difference between that price and the average price of the cars sold in that city. (5 marks) Note: Some flels may have been stored in different case spellings in the database; for example On and ON or TORONTO, toronto, and Toronto. Make sure to include all different kinds of spellings for the fields that represent the same value. For this assignment you must use si schema 1. Show the total allowance amount, the average allowance amount, as well as the number cars traded in during the year of 2018 for Mercedes, Acura, Land Rover and Jaguar makes Note: The allowance for each car that is traded in is stored in tradeallow of the tradeinu table. (5 marks). 2. The salespeople performances are evaluated based on the number of cars they have sold. Their performance is classified as:: o Low - if they have sold less than 20 cars Medium - if they have sold between 20 and 30 cars High - if they have sold more than 30 cars Show the names of the salespeople (job title-salesman) and their level of performance. (5 marks) 3. Using SET operation show the names and home phone numbers of the customers, who own cars of make Land Rover, and they have never brought their 4. Show the total amount of money that customers from the province of Alberta (AB) have spent on labor when servicing their cars. Show the subtotals for each city from that provice.(5 marks) 5. Using analytic functions display the highest and the lowest carsaleprice for each car make and rank them based on the highest price in descending order. (5 marks) 6. Using analytic functions return the name of the customer who bought the third most expensive car. (5 marks) 7. For each customer from London, return the price of the car they bought and the difference between that price and the average price of the cars sold in that city. (5 marks) or this assignment you must use si schema 1. Show the total allowance amount, the average allowance amount, as well as the number cars traded in during the year of 2018 for Mercedes, Acura, Land Rover and Jaguar makes. Note: The allowance for each car that is traded in is stored in tradeallow of the tradeiny table. (5 marks). 2. The salespeople performances are evaluated based on the number of cars they have sold. Their performance is classified as: Low - if they have sold less than 20 cars Medium - if they have sold between 20 and 30 cars High - if they have sold more than 30 cars Show the names of the salespeople (job title - salesman) and their level of performance. (5 marks) 3. Using SET operation show the names and home phone numbers of the customers, who own cars of make Land Rover, and they have never brought their cars in for service. (5 marks) 4. Show the total amount of money that customers from the province of Alberta (AB) have spent on labor when servicing their cars. Show the subtotals for each city from that provice (5 marks) 5. Using analytic functions display the highest and the lowest carsaleprice for each car make and rank them based on the highest price in descending order. (5 marks) 6. Using analytic functions return the name of the customer who bought the third most expensive car. (5 marks) 7. For each customer from London, return the price of the car they bought and the difference between that price and the average price of the cars sold in that city. (5 marks) Note: Some flels may have been stored in different case spellings in the database; for example On and ON or TORONTO, toronto, and Toronto. Make sure to include all different kinds of spellings for the fields that represent the same value. For this assignment you must use si schema 1. Show the total allowance amount, the average allowance amount, as well as the number cars traded in during the year of 2018 for Mercedes, Acura, Land Rover and Jaguar makes Note: The allowance for each car that is traded in is stored in tradeallow of the tradeinu table. (5 marks). 2. The salespeople performances are evaluated based on the number of cars they have sold. Their performance is classified as:: o Low - if they have sold less than 20 cars Medium - if they have sold between 20 and 30 cars High - if they have sold more than 30 cars Show the names of the salespeople (job title-salesman) and their level of performance. (5 marks) 3. Using SET operation show the names and home phone numbers of the customers, who own cars of make Land Rover, and they have never brought their 4. Show the total amount of money that customers from the province of Alberta (AB) have spent on labor when servicing their cars. Show the subtotals for each city from that provice.(5 marks) 5. Using analytic functions display the highest and the lowest carsaleprice for each car make and rank them based on the highest price in descending order. (5 marks) 6. Using analytic functions return the name of the customer who bought the third most expensive car. (5 marks) 7. For each customer from London, return the price of the car they bought and the difference between that price and the average price of the cars sold in that city