SQL Programming
Go to ProblemsSQL Introduction
SQL is Structured Query Language, which is a programming language for storing, manipulating and retrieving data stored in a relational database.
SQL is the standard language for Relational Database System. All the Relational Database Management Systems (RDMS) like MySQL, MS Access, Oracle, Sybase, Informix, Postgres and SQL Server use SQL as their standard database language.
SQL Process
When a SQL command is executed in any RDBMS, the system determines the best way to carry out your command and SQL engine figures out how to interpret the task.
Components like Query Dispatcher, Optimization Engines, Classic Query Engine, SQL Query Engine etc are involved in this process.
Note: A classic query engine handles all the non-SQL queries, but a SQL query engine won't handle logical files.
| Problem | Score | Companies | Time | Status |
|---|---|---|---|---|
| Performance Improvement | 50 |
|
31:02 | |
| Minimum GPA | 50 |
|
38:12 | |
| Number of offers | 50 |
|
35:19 | |
| Neutral Reviewers | 100 |
|
25:02 | |
| Movie Character | 100 |
|
35:17 | |
| Short Films | 100 |
|
31:43 |
| Problem | Score | Companies | Time | Status |
|---|---|---|---|---|
| Study Selection | 50 |
|
9:31 | |
| Study Update | 50 |
|
18:20 | |
| Study Deletion | 50 |
|
12:26 | |
| Job Offers 2.0 | 50 |
|
26:08 | |
| Actors and their Movies | 100 |
|
38:58 |
| Problem | Score | Companies | Time | Status |
|---|---|---|---|---|
| Town Selection | 50 |
|
8:29 | |
| Town Queries | 50 |
|
5:29 | |
| Student Query | 50 |
|
8:12 | |
| Country Filtration | 50 |
|
6:08 | |
| Information Selector | 50 |
|
3:56 | |
| Town Of Threes | 50 |
|
8:32 |
| Problem | Score | Companies | Time | Status |
|---|---|---|---|---|
| Firefighter's Average | 50 |
|
10:46 | |
| Firefighter's Sum | 50 |
|
6:27 | |
| Largest Difference | 50 |
|
13:46 | |
| Distance Maximizer | 50 |
|
16:20 | |
| Euclid's Distance | 50 |
|
18:18 | |
| Big Salary | 50 |
|
21:10 | |
| 5'th Highest Marks | 50 |
|
23:36 | |
| Famous Books | 50 |
|
27:37 | |
| Chess Tournament | 50 |
|
31:47 | |
| NULL sorting | 50 |
|
26:08 | |
| I hate Vowels | 50 |
|
27:05 | |
| Birthdays | 50 |
|
21:33 | |
| Class Average | 50 |
|
20:58 | |
| Tournament 2.0 | 50 |
|
25:48 | |
| Job Offer | 50 |
|
24:49 | |
| Next And Previous | 50 |
|
21:57 |
| Problem | Score | Companies | Time | Status |
|---|---|---|---|---|
| Conditional Work | 50 |
|
22:12 | |
| Role Ordering | 50 |
|
28:54 | |
| Role Player | 50 |
|
16:10 | |
| Role Counter | 50 |
|
16:59 | |
| Vowel Country | 50 |
|
15:06 |
| Problem | Score | Companies | Time | Status |
|---|---|---|---|---|
| Engineers Joined | 50 |
|
25:23 | |
| Many Tables | 50 |
|
21:34 | |
| Top Performer | 50 |
|
30:22 | |
| Low and High Grades | 50 |
|
23:52 | |
| Same Countries | 50 |
|
23:42 |
