Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Coding Interview Guide
00 Intro Section
00 Course Overview (4:21)
01 Restrict and Soft Data Question
00 Build A Table And Display All Records (10:26)
01 List Alphabetically (4:12)
02 List All Not In Specified Range (4:03)
03 List All In Range By Multiple Properties (7:39)
04 Display All With Characters In Property (6:09)
05 Select From Where In This And Not In That (6:09)
06 List All With Exact Number Of Characters (5:44)
07 List All With Specific Second Character (5:11)
08 List All Distinct Ids Available (3:36)
09 Calculate Percentage (4:45)
10 Consecutive Numbers (9:03)
Source Code
02 Join Data Questions
01 List Streams With Viewer Information (9:33)
02 Join Two Tables (5:18)
03 Find Same Value In Another Property (8:08)
04 List Values Across Tables (6:34)
05 Join Three Tables (6:44)
06 Find Average Across Tables (6:59)
07 Display Difference Across Tables (6:27)
08 Find More Than Value Across Tables (6:11)
09 Product Sales Analysis (6:50)
10 List All After A Certain Date (6:33)
11 Capital Gain Loss (6:33)
Source Code
03 Aggregate Functions Questions
01 Count Distinct Properties (3:47)
02 List Total Sum (3:40)
03 Get Minimum (3:12)
04 Get Maximum From A Distinct Type (4:12)
05 Get Average And Count At An Id (3:22)
06 Get Number Of Same Type (3:05)
07 Get Difference Between Max And Min (2:30)
08 Find Minimum Of Each Type (5:13)
09 Get Sum At Each Id (3:39)
10 Get Average For Each Id (4:40)
11 Get Different Properties (4:29)
12 List Where Maximum Is Greater Than (4:34)
13 List Average Where Greater Than (6:16)
Source Code
04 SubQuery Questions
01 Find Higher Values (8:03)
02 Find All Of A Type (6:40)
03 List All Above Average (5:10)
04 List All Greater Than Minimum (7:52)
05 List All Part Of Any (7:57)
06 List All Who Have More (6:24)
07 List All With Same As Minimum (4:41)
08 List All Above Average In Their Group (6:35)
09 Get Kth Maximum Value (6:48)
10 Get Kth Minimum Value (5:27)
11 Select Last K Records From A Table (5:01)
12 List All Not In A Group (5:12)
13 Get K Maximum Values (4:58)
14 Get K Minimum Values (3:47)
15 Products Never Sold (4:17)
16 Winning Candidate (5:38)
17 Search Across Three Tables (7:51)
18 Find One Property In Another (4:38)
Source Code
05 Select From Where In This And Not In That
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock