Practice on Employee Table:
Table Creation
Inserting Values
Retrieving Data
1) Get the max salary employee.
2) Get the employees whose salary is less than the average salary
3) Get all the cities in country US
4) Get country wise maximum salary
5) Country wise employee count
6) Get the list of employees whose first name first name is equal to last name last letter
7) Get the employee name whose name does't contain vowels
8) Get the list of employees whose first name length is greater than last name length
Practice Section 1:
1) Get the count of customers from each city
2) Get the max number of customers in which city
3) Get the City where we have customers but no suppliers
4) Get the City Where we have suppliers but no customer
5) Get the customer who given highest order
6) Get the high sold items
7) Get the item which is not sold as of now
8) Get me the order which has maximum items on order
9) Get me the customer's wise orders items list
10) Get me the customer who taken maximum items
Practice Section 2:
Location Table:
Team Table:
Dept Table:
Monitor Table:
Cpu Table:
1) Query to get department wise employee count:
2) Query to get department wise average salary
3) Query to get employees whose salaries are less than department wise average salary
4) Query to get employee details,department details and head of the department details
5)Query to get employee details with their monitor,cpu details
6) Query to get employee details with their monitor,cpu details, head of the department with monitor,cpu details
Including all employees even they don't assigned in the departments
