Introduction to SQL Coding Practice Challenges | CodeNivo

Question 1

Using the students table from this lesson, write a query that returns every column for every student and sorts the results by student_id.

Accepted Answer

SELECT *
FROM students
ORDER BY student_id;

Answer

-- Write your query below

Question 2

Write a query that returns the name and age of students whose age is greater than 19. Sort the results by student_id.

Accepted Answer

SELECT name, age
FROM students
WHERE age > 19
ORDER BY student_id;

Answer

-- Write your query below

Question 3

11. Guided Practice

Accepted Answer

-- Task 1
SELECT *
FROM students;

-- Task 2
SELECT name, city
FROM students;

-- Task 3
SELECT name, age
FROM students
WHERE age > 19;

-- Task 5
CREATE TABLE departments (
    department_id INTEGER PRIMARY KEY,
    department_name VARCHAR(100) NOT NULL
);

Answer

-- Practice query for Relational Databases, Tables, Rows, and Columns

Question 4

15. Guided Practice

Accepted Answer

psql -h localhost -p 5432 -U postgres -d postgres

Answer

-- Practice query for Installing SQL and Setting Up Your Environment

name	age
Aman	20
Priya	21

Introduction to SQL Problems