SQL-Practice: A PLpgSQL repository from aakriti-sharma

Day 1 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 2 :
- Q 1 - Employees Earning More Than Their Managers
- Q 2 - Duplicate Emails
- Q 3 - Customers Who Never Order
- Q 4 - Big Countries
- Q 5 - Rising Temperature
Day 3 :
- Q 1 - Classes More Than 5 Students
- Q 2 - Combine Two Tables
- Q 3 - Not Boring Movies
- Q 4 - Second Highest Salary
- Q 5 - Nth Highest Salary
Day 4 :
- Q 1 -
- Q 3 -
- Q 4 -
- Q 5 -
- Q 6 -
- Q 7 - Swap Salary
Day 5 :
- Q 1 - Members Whose Scores Exceed the Group leader
- Q 2 - Find a Classmate with the Same Name
- Q 3 - Players Who Never Recharge
- Q 4 - Increasing Number of Infections
- Q 5 - At Least Three Players Have Scored
Day 6 :
- Q 1 - Analysis of Online Class I
- Q 2 - Public Rental Housing Information Query
- Q 3 - Coin Flip
- Q 4 - Students with the Most Failed Subjects I
- Q 5 - Zhang San's Story I
Day 7 :
- Q 1 - Find Right Triangle
- Q 2 - Bike Sharing
- Q 3 - Check the average age of teachers at the end of the specified mailbox
- Q 4 - Calculate the number of years difference between the start date and the current date of all courses in the course schedule
- Q 5 - Calculate the number of months difference between the start date and the current date of all courses in the schedule
Day 8 :
- Q 1 - Creating a simple SQL View (II)
- Q 2 - Creating a simple SQL View (I)
- Q 3 - Insert Kansas information into the teacher table
- Q 4 - Update the age of Linghu Chong
- Q 5 - Highest scoring player in the team
Day 9 :
- Q 1 - Nth highest player height
- Q 2 - Height of players appearing consecutively
- Q 3 - Count the total number of students taught by each faculty member
- Q 4 - Player Height Ranking1
- Q 5 - Count the total number of students in each teacher's course
Day 10 :
- Q 1 - Statistics on the number of courses taught by each teacher
- Q 2 - Search for information on the oldest faculty member whose nationality is American
- Q 3 - Search for course information for courses with more students than the number of students in all courses of the oldest teacher
- Q 4 - Search for the name of a course created later than the creation time of any of the specified teacher's courses
- Q 5 - Consecutive Empty Boxes
Day 11 :
- Q 1 - Use NOT BETWEEN to search for teachers with Chinese nationality
- Q 2 - Search for information on courses and instructors with the highest number of students
- Q 3 - Show view in the current database
- Q 4 - Redefining the teachers view
- Q 5 - Delete Linghu Chong's message
Day 12 :
- Q 1 - Withdrawal of age update for Linghu Chong
- Q 2 - Check the number of teachers in different countries
- Q 3 -
- Q 4 -
- Q 5 -
Day 13 :
- Q 1 - Danny's Diner 1
- Q 2 - Danny's Diner 2
- Q 3 - Danny's Diner 3
- Q 4 - Danny's Diner 4
- Q 5 - Danny's Diner 5
Day 14 :
- Q 1 - Danny's Diner 6
- Q 2 - Danny's Diner 7
- Q 3 - Danny's Diner 8
- Q 4 - Danny's Diner 9
- Q 5 - Danny's Diner 10
Day 15 :
- Q 1 - Danny's Diner 11
- Q 2 - Danny's Diner Bonus 1
- Q 3 - Danny's Diner Bonus 2
- Q 4 -
- Q 5 -
Day 16 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 17 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 18 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 19 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 20 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 21 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 22 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 23 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 24 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 25 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 26 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 27 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 28 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 29 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 30 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -
Day 31 :
- Q 1 -
- Q 2 -
- Q 3 -
- Q 4 -
- Q 5 -

aakriti-sharma/SQL-Practice