MySQL Exercises

Write a query to show the total balance using debit and credit entries

Write a query to show the count of students by city

Write a query to show the student name who has the second highest marks

Write a query to show the average marks of each city

Write a query to get all column names of a database table

Write a query to get data of selected columns from a table

Write a query to select the student with the maximum marks

Write a query to select top 3 students by marks

Write a query to find the cities that have more than one student

Write a query to update a column based on a condition

Write a query to update the value of a column using concatenation

Write a query to select the rows if a column has no value

Write a query to fetch the names of the students in upper case

Write a query to fetch the number of students from Delhi

Write a query to retrieve the first four characters of the name

Write a query to create a new table with the data and structure of another table

Write a query to find the names of students that begin with ‘A’

Write a query to fetch the top 2 records

Write a query to show the names of students with their course names

Write a query to count the students of each course, including empty courses