SQL Programming

Sql joins

Problem	Score	Companies	Time	Status
Performance Improvement	50		31:09
Minimum GPA	50		38:24
Number of offers	50		35:32
Neutral Reviewers	100		25:02
Movie Character	100		35:17
Short Films	100		31:49

Sql sub queries

Problem	Score	Companies	Time	Status
Study Selection	50		9:33
Study Update	50		18:24
Study Deletion	50		12:35
Job Offers 2.0	50		26:15
Actors and their Movies	100		38:58

Basic select

Problem	Score	Companies	Time	Status
Town Selection	50		8:31
Town Queries	50		5:29
Student Query	50		8:17
Country Filtration	50		6:08
Information Selector	50		3:56
Town Of Threes	50		8:33

Aggregation

Problem	Score	Companies	Time	Status
Firefighter's Average	50		10:52
Firefighter's Sum	50		6:29
Largest Difference	50		13:48
Distance Maximizer	50		16:27
Euclid's Distance	50		18:18
Big Salary	50		21:12
5'th Highest Marks	50		23:39
Famous Books	50		27:44
Chess Tournament	50		32:04
NULL sorting	50		26:22
I hate Vowels	50		27:20
Birthdays	50		21:34
Class Average	50		21:05
Tournament 2.0	50		26:00
Job Offer	50		24:52
Next And Previous	50		21:57

Advanced select

Problem	Score	Companies	Time	Status
Conditional Work	50		22:16
Role Ordering	50		28:51
Role Player	50		16:23
Role Counter	50		17:08
Vowel Country	50		15:10

Basic join

Problem	Score	Companies	Time	Status
Engineers Joined	50		25:27
Many Tables	50		21:39
Top Performer	50		30:35
Low and High Grades	50		24:00
Same Countries	50		23:47