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
13 List Average Where Greater Than
Lesson content will be unlocked within 30 minutes.
Teachable is working on this bug.
No further action will be required on your part
.
Thank you for your patience