SQL Beginner Interview Questions-Writing Queries

These queries cover a range of basic operations and can serve as a good starting point for entry-level interview preparation. Make sure to understand the logic behind each query and practice writing them on your own.

These are tables you can use as a reference

Retrieve all columns from a table named Customers.

SELECT * FROM Customers;

Retrieve the names and ages of all customers.

SELECT Name, Age FROM Customers;

Find the total number of customers.

SELECT COUNT(*) FROM Customers;

Retrieve unique cities from the Customers table

SELECT DISTINCT City FROM Customers;