SQL Interview Questions & Query Practice — LeetCode 50 SQL | PrepWix | PrepWix

SQL

SQL Interview Questions & Query Practice — LeetCode 50 SQL | PrepWix | PrepWix

20/20

Topics

Problem Library20

Topics

Diff.

LeetCode

1607. Sellers With No Sales

Amazon

Easy

1587. Bank Account Summary II

join

joingroup byhaving

Easy

1527. Patients With a Condition

like

likestring matching

Easy

1517. Find Users With Valid E-Mails

regexp

regexpstring functions

Easy

1495. Friendly Movies Streamed Last Month

join

joindistinctdate filtering

Easy

1454. Active Users

correlated-subquery

correlated subquerygaps and islandsdate functions

Medium

1407. Top Travellers

join

joinleft joingroup by+1

Easy

1350. Students With Invalid Departments

subquery

subquerynot in

Easy

1327. List the Products Ordered in a Period

join

joingroup byhaving

Easy

1179. Reformat Department Table

pivot

pivotconditional aggregationgroup by

Easy

1126. Active Businesses

correlated-subquery

correlated subquerygroup byhaving

Medium

1084. Sales Analysis III

group-by

group byhavingjoin

Easy

1082. Sales Analysis I

group-by

group byhavingsubquery

Easy

1050. Actors and Directors Who Cooperated At Least Three Times

group-by

group byhaving

Easy

627. Swap Salary

update

updatecase when

Easy

626. Exchange Seats

case-when

case whensubqueryorder by

Medium

619. Biggest Single Number

subquery

subquerygroup byhaving

Easy

610. Triangle Judgement

case-when

case when

Easy

607. Sales Person

subquery

subqueryjoinnot in

Easy

596. Classes More Than 5 Students

group-by

group byhavingdistinct

Easy