code the query


“THE MOST EFFICIENT WAY TO OPTIMIZE A SQL QUERY IS TO ELIMINATE IT”
There are two types of a software development – Backend & Frontend. Front-end = what you see; back-end = how it works. If you’re going to decide “how it works” you should be a great Database Administrator, consequently you should be great at writing SQL queries. So, we're here with a CODE THE QUERY event to provide you all a platform to test your skills in solving SQL QUERIES.
" Be a Challenger and take a Challenge to CODE THE QUERY".

Event Format:

  • The event consists of two rounds.

TEAM SIZE:

  • Individual Participation is Allowed.

QUIZ ROUND

    All Participants need to solve 30 MCQ questions in given 45 min. Quiz round will be based on offline mode(Pen - Paper Test Type). 20 MCQ questions will be purely based on basics of SQL (I.e. Both Queries and fundamentals of SQL). Remaining 10 MCQ questions can be from basics of database and may also contain some SQL queries again. Top 10 participants will be selected for 2 nd round on the merit basis. All questions carry equal marks.

Final round

    Maximum time limit for this round is 60mins. A separate laptop will be provided to each participant. System will contain database of multiple tables on the basis of which Participants need to run 15 Queries on command prompt. At last some points will be rewarded for each correct query and on the basis of their early submission. Ultimately the participant who will score the highest will be declared as Winner.

QUERIES TYPE :

  1. TYPE A – 10 queries will be based on to apply LIKE,WHERE,OR,AND,BETWEEN,ORDER BY, GROUP BY, COUNT, MIN MAX ,AVG (i.e. Some clauses, operators and aggregation functions) on a single given table
  2. TYPE B – 5 Queries will be based on performing joins and writing sub Queries for multiple tables.

POINTS SCHEME

  1. A participant can earn maximum of 500 points
  2. 5 points will be rewarded for each correct solution for TYPE A Query
  3. 10 points will be rewarded for each correct solution for TYPE B Query
  4. Total points earned by participant will be further multiply by 5,4,3,2,1 on the basis of their submission time as mentioned below
    0 – 15mins (5x)
    15 -30mins (4x)
    30 – 40mins (3x)
    40 – 50mins (2x)
    50 – 60mins (1x)

PRIZE

  1. WINNER:- /-

  2. 1st RUNNER-UP:- /-

Event Coordinator


AMAN KUMAR

Ph no.8962659180




58in this event
TEAMS
67in this event
PARTICIPANTS

Events