SQL Exercises

SQL Exercise is the second section of DataCTFs for learning data science. It consist of a series of exercises covering various concepts in database with SQL structured query language.

Harness your database querying skills by performing SQL Exercises.

SQL Exercises

Practice here

SQL Exercise - Basics

Get better with the fundamentals via our cool & rewarding useful data exercises.

  • child_care Task 1: 1

    . Write a Query to Display all the information in the current table. (Table Name:country)

    . Table Name:country

    .

    . nan

    Attempt
  • child_care Task 1: 2

    . Show the name and the population for all data in table

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 3

    . Show all the fields for the first 5 rows from the country table

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 4

    . Show all the details for the country 'India', from the country table

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 5

    . Given the Country Table, show the name and the population for 'Ghana', 'India','Germany' and 'Norway'

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 6

    . Find the names of the countries with life expectancy between 79 and 80

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 7

    . Find the names of countries that got independence(IndepYear) between the year 1990 and 2000

    . Table Name: Country

    .

    . nan

    Attempt
  • child_care Task 1: 8

    . Display the names of every country that starts with G.

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 9

    . Display the names of every country that has their names ending with 'i'.

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 10

    . Find the names of every country that belongs to the continent that is located in the South;

    . Table Name:country

    .

    . nan

    Attempt
  • child_care Task 1: 11

    . Show the name,population and area of countries with area more than 3million

    . Table Name:country

    .

    . nan

    Attempt
Sql Exercise - Intermediate

Get better with the fundamentals via our cool & rewarding useful data exercises.

  • child_care Task 1: 1

    . Write a Query to Display all the information in the current table. (Table Name:country)

    . Table Name:country

    .

    . nan

    Attempt
  • child_care Task 1: 2

    . Show the name and the population for all data in table

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 3

    . Show all the fields for the first 5 rows from the country table

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 4

    . Show all the details for the country 'India', from the country table

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 5

    . Given the Country Table, show the name and the population for 'Ghana', 'India','Germany' and 'Norway'

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 6

    . Find the names of the countries with life expectancy between 79 and 80

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 7

    . Find the names of countries that got independence(IndepYear) between the year 1990 and 2000

    . Table Name: Country

    .

    . nan

    Attempt
  • child_care Task 1: 8

    . Display the names of every country that starts with G.

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 9

    . Display the names of every country that has their names ending with 'i'.

    . Table Name: country

    .

    . nan

    Attempt
  • child_care Task 1: 10

    . Find the names of every country that belongs to the continent that is located in the South;

    . Table Name:country

    .

    . nan

    Attempt
  • child_care Task 1: 11

    . Show the name,population and area of countries with area more than 3million

    . Table Name:country

    .

    . nan

    Attempt
insert_chart