SQL Programming

Sql joins

Problem	Score	Companies	Time	Status
Performance Improvement	50		27:39
Minimum GPA	50		31:30
Number of offers	50		29:14
Neutral Reviewers	100		24:55
Movie Character	100		34:51
Short Films	100		31:08

Sql sub queries

Problem	Score	Companies	Time	Status
Study Selection	50		9:01
Study Update	50		17:16
Study Deletion	50		11:24
Job Offers 2.0	50		23:13
Actors and their Movies	100		38:16

Basic select

Problem	Score	Companies	Time	Status
Town Selection	50		7:48
Town Queries	50		5:16
Student Query	50		7:32
Country Filtration	50		6:03
Information Selector	50		3:37
Town Of Threes	50		8:14

Aggregation

Problem	Score	Companies	Time	Status
Firefighter's Average	50		9:59
Firefighter's Sum	50		6:12
Largest Difference	50		12:43
Distance Maximizer	50		15:01
Euclid's Distance	50		16:29
Big Salary	50		19:28
5'th Highest Marks	50		22:17
Famous Books	50		24:26
Chess Tournament	50		26:36
NULL sorting	50		21:50
I hate Vowels	50		26:42
Birthdays	50		15:56
Class Average	50		17:16
Tournament 2.0	50		25:13
Job Offer	50		21:58
Next And Previous	50		19:02

Advanced select

Problem	Score	Companies	Time	Status
Conditional Work	50		20:08
Role Ordering	50		26:59
Role Player	50		13:53
Role Counter	50		13:28
Vowel Country	50		13:12

Basic join

Problem	Score	Companies	Time	Status
Engineers Joined	50		23:59
Many Tables	50		19:30
Top Performer	50		24:47
Low and High Grades	50		20:02
Same Countries	50		19:36