SQL Challenge Series | Filtering & Sorting Queries Explained

Añadido: 2026-06-01

[00:00:00]Good evening, folks.

[00:00:05]But since this focus on the map Show employee records from Chennai with salary above 60,000.

[00:00:22]source requirement source table employees table column requirement Next important section, filtration requirement.

[00:00:53]In a little bit longer, the employee city has to be Chennai.

[00:00:58]has to be from Chennai and so The employee salary has to be greater than 60,000 and so on.

[00:01:14]Number or special conditional operator in the use for all of the and operator.

[00:01:32]So, select the entire records from employee table where the city has to be Chennai. So, make sure the text values are wrapped in single quotes and the salary should be greater than 60,000.

[00:01:49]Show employees sorted by highest salary.

[00:01:51]In here, source and column requirements >> It was a simple display query that employee records are certain order The employee records has to be sorted based on salary.

[00:02:10]And the salary has to be from highest to lowest. So in the employee highest records in the top layer display panel.

[00:02:22]So select the entire records from employees.

[00:02:28]Order by keyword that you can use for the product keyword. In the column base So now I'm going to salary column could grow.

[00:02:37]So order by keyword sort by the help and know You don't know how to execute by the report. This is less records sort by the display are you can park lot but It is sorted from highest to lowest.

[00:02:54]But it is sorted from lowest to highest in our order by the keyword default.

[00:02:58]Ascending order that sort by the note.

[00:03:00]Descending order that sort by the number descending by the keyword If you need a button by the number records are sorted based on salary from highest to lowest.

[00:03:11]Special keyword that descending.

[00:03:13]In the queries that is the modification you can find by the plan. So get the employee names who are from Chennai and get the count of employee records who are from Chennai and whose salary is above 60,000. Okay. Now In the queries kind of results comment section solution The knowledge of the challenge video that I discuss by the plan.