A retail company manages its sales operations with a database that includes information about salesmen, customers, and orders. Your task is to write a query that counts the number of customers with grades above the average grade in the city of Bangalore.The following table is already created, and the records are inserted into the table.The Sample records are Input format :The input records are already prepopulated, as given in the problem statement.Output format :The result of the query is the count of customers whose grade is above the average grade of customers in Bangalore.AboveAverageGradesCount6Refer to the sample output for the column headers

A retail company manages its sales operations with a database that includes information about salesmen, customers, and orders. Your task is to write a query that counts the number of customers with grades above the average grade in the city of Bangalore.The following table is already created, and the records are inserted into the table.

Write a query to display the student qualification(squal) and the total number of students based on their qualifications. Give an alias name as ‘totalStud’. Display only the squal having the totalStud count less than 8. Display the records sorted in ascending order based on squal.

You are tasked with managing sales data for a company. The data includes information about salesmen, customers, and orders. Write a query to find the name and numbers of all salesmen who had more than one customer.The following table is already created, and the records are inserted into the table.The Sample records are given below Input format :The input records are already prepopulated, as given in the problem statement.Output format :The output should include the Salesman_id, Salesman_Name, and Customer_Count for all salesmen who had more than one customer as shown below.Salesman_id Salesman_Name Customer_Count5 Chris Wilson 2Refer to the sample output for the column headers.

You have a database that tracks students in the students table by student_id. The names of the semesters are in a semesters table where the primary key is semester_id. Each semester, students are assigned a grade_point_average which is stored in the grades table. The grades table lists the student_id and the semester_id in addition to the grade_point_average.You need to create a query that finds all the semesters where the student had a grade point average that was less than their average grade point average. You begin typing your query:What should you type in the blank space? (Please type your answer all in lower case. Example: select)

2.Question 2You are the database administrator for a school. Student information is kept in a students table where students are tracked by student_id. Students have a grade point average listed for each semester in a table named grades where each student is referenced by student_id.The school is giving an award to all students who achieved a 4.0 grade point average during any semester. You need to generate a list of all the students who should get the award. You begin typing your query:What should you type in the blank space? (Please type your answer all in lower case. Example: select)1 point