SQL Programming

Sql joins

Problem	Score	Companies	Time	Status
Performance Improvement	50		29:23
Minimum GPA	50		35:33
Number of offers	50		32:16
Neutral Reviewers	100		24:59
Movie Character	100		35:03
Short Films	100		31:27

Sql sub queries

Problem	Score	Companies	Time	Status
Study Selection	50		9:14
Study Update	50		17:51
Study Deletion	50		11:47
Job Offers 2.0	50		24:35
Actors and their Movies	100		38:36

Basic select

Problem	Score	Companies	Time	Status
Town Selection	50		8:04
Town Queries	50		5:22
Student Query	50		7:49
Country Filtration	50		6:05
Information Selector	50		3:51
Town Of Threes	50		8:25

Aggregation

Problem	Score	Companies	Time	Status
Firefighter's Average	50		10:16
Firefighter's Sum	50		6:16
Largest Difference	50		13:14
Distance Maximizer	50		15:47
Euclid's Distance	50		17:24
Big Salary	50		20:10
5'th Highest Marks	50		22:53
Famous Books	50		26:14
Chess Tournament	50		29:13
NULL sorting	50		23:40
I hate Vowels	50		25:24
Birthdays	50		18:05
Class Average	50		19:07
Tournament 2.0	50		25:16
Job Offer	50		23:00
Next And Previous	50		21:27

Advanced select

Problem	Score	Companies	Time	Status
Conditional Work	50		21:16
Role Ordering	50		27:31
Role Player	50		15:07
Role Counter	50		15:11
Vowel Country	50		14:13

Basic join

Problem	Score	Companies	Time	Status
Engineers Joined	50		24:40
Many Tables	50		20:23
Top Performer	50		27:55
Low and High Grades	50		21:45
Same Countries	50		21:48