Write a MySQL query to get the difference between the highest and lowest salaries

MySQL basic SELECT statement – Exercises

by

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
  1. Write a query to display the names (firstname, lastname) using alias name “First Name”, “Last Name”
  2. Write a MySQL query to get unique branch from student table
  3. Write a MySQL query to get the details of all students according to first name in descending order
  4. Write a MySQL query to get the names (firstname, lastname), Fee, Scholarship of all the student (Scholarship is calculated as 15% of Admission Fee)
  5. Write a query to get the student ID, names (firstname, lastname), admission Fee in ascending order of admission Fee
  6. Write a MySQL query to get the total admission fee of students
  7. Write a MySQL query to get the maximum and minimum admission fee from students table
  8. Write a MySQL query to get the average admission fee and number of students in the students table
  9. Write a MySQL query to get the number of students studying in the institute
  10. Write a query get all first name from students table in lower case
  11. Write a query get all first name from students table in upper case
  12. Write a query get the first 3 characters of first name from students table
  13. Write a MySQL query to calculate 401*14+1025-500
  14. Write a query to get monthly admission fees of each and every student
  15. Write a MySQL to get query to first 5 records from a table
  16. Write a MySQL to get first name of all students table after removing white spaces from both side

Leave a Comment