The following exercise will help you to improve your MySQL query skills effectively. I have used phpMyAdmin for the following Exercises
– students
| StudentId | FirstName | LastName | Admission_fee | Admission_date | Branch |
|---|---|---|---|---|---|
| 1 | John | Smith | 1000 | 2018-06-10 | Computer Engineering |
| 2 | David | Jones | 1200 | 2018-06-20 | Civil Engineering |
| 3 | Michael | Johnson | 900 | 2018-08-15 | Chemical Engineering |
| 4 | Chris | Lee | 1500 | 2018-07-10 | Electrical Engineering |
| 5 | Mike | Brown | 1600 | 2018-09-10 | Mechanical Engineering |
| 6 | Lisa | Smith | 1800 | 2018-07-10 | Computer Engineering |
| 7 | Mary | Smith | 1600 | 2018-06-11 | Computer Engineering |
- Write a MySQL query to list the number of branchs available in the student table
- Write a MySQL query to get the total admission fee of all students
- Write a MySQL query to get the minimum admission fee from students table
- Write a MySQL query to get the maximum admission fee from students table
- Write a MySQL query to get the average fee and number of students studying in ‘Computer Engineering’
- Write a MySQL query to get the highest, lowest, sum, and average salary of all students
- Write a MySQL query to get the number of students with the same branch
- Write a MySQL query to get the difference between the highest and lowest salaries
- Write a MySQL query to get Branch ID and the total admission fee of each branch
- Write a MySQL query to get the average admission fee for each branch excluding ‘Computer Engineering’
- Write a MySQL query to get the total salary, maximum, minimum, average salary of students(Branch ID wise), for Branch ID 111 only
- Write a MySQL query to get the branch ID and maximum fee of the students where maximum fee is greater than or equal to 1000
- Write a MySQL query to get the average fee for all students more than 2 students stuyding in same branch