SQL Basic Question for interview

Let's come to the point.

I have created an Awesome SQL Interview GitHub repo to prepare for interview questions and practice SQL queries. I have divided the SQL queries into three sections: Basic (L0), Intermediate (L1), and Advanced (L2). This is the solution for the basic section.

---

L0: Basic SQL

• Questions related to basic SQL commands such as SELECT, INSERT, UPDATE, and DELETE.
• Queries related to basic data manipulation and retrieval from simple tables.

Query Questions:

1. How do you display all columns and rows from the customers table?
2. Write a query to retrieve only the customerName and phone from the customers table.
3. How do you list all rows where country is 'USA' in the customers table?
4. Write a query to find all products in the products table with a buyPrice less than 50.
5. How do you fetch all orders with a status of 'Shipped' from the orders table?
6. Write a query to display the productName and quantityInStock for all products in the products table.
7. How do you find the distinct country values in the customers table?
8. Write a query to count the total number of customers in the customers table.
9. How do you retrieve all employees whose jobTitle is 'Sales Rep'?
10. Write a query to sort the products table by productName in ascending order.
11. How do you fetch the customerName and city of all customers located in 'Paris'?
12. Write a query to display the top 10 orders from the orders table based on the orderDate.
13. How do you retrieve all offices located in the USA?
14. Write a query to display all employees who work in the office located in 'San Francisco'.
15. How do you calculate the total number of orders placed in the orders table?
16. Write a query to display the productName of all products in the products table where productLine is 'Classic Cars'.
17. How do you find the customerName of all customers whose creditLimit is greater than 50,000?
18. Write a query to fetch all products that have a quantityInStock between 10 and 100.
19. How do you retrieve all orders placed in the year 2003?
20. Write a query to display the employeeNumber and firstName of employees whose last names start with 'B'.

Solution with explanation

1. How do you display all columns and rows from the customers table?
   

2. Write a query to retrieve only the customerName and phone from the customers table.
   

3. How do you list all rows where country is 'USA' in the customers table?
   

4. Write a query to find all products in the products table with a buyPrice less than 50.
   

5. Fetch all orders with a status of 'Shipped' from the orders table.
   

6. Display the productName and quantityInStock for all products in the products table.
   

7. Find the distinct country values in the customers table.
   

8. Count the total number of customers in the customers table.
   

9. Retrieve all employees whose jobTitle is 'Sales Rep'?
   

10. Sort the products table by productName in ascending order.
    

11. Fetch the customerName and city of all customers located in 'Paris'.
    

12. Display the top 10 orders from the orders table based on the orderDate.
    

13. Retrieve all offices located in the USA.
    

14. Display all employees who work in the office located in 'San Francisco'.
    

15. Calculate the total number of orders placed in the orders table.
    

16. Display the productName of all products in the products table where productLine is 'Classic Cars'.
    

17. Find the customerName of all customers whose creditLimit is greater than 50,000.
    

18. Fetch all products that have a quantityInStock between 10 and 100.
    
    

19. Retrieve all orders placed in the year 2003?
    

20. Display the employeeNumber and firstName of employees whose last names start with 'B'.
    

---

Hey, My name is Jaimin Baria AKA Cloud Boy..., If you have enjoyed and learned something useful, like this post, add a comment, and visit my Awesome SQL Interview GitHub repo.

Don't forget to give it a start 😅.

Happy Coding 🧑‍💻

---

Other Posts

• Part 1
  • L0: Basic SQL
  • L1: Intermediate SQL
  • L2: Advanced SQL - Will Come soon

---

🛠️ Fixes Suggested by Readers

1. Fetch all products that have a quantityInStock between 10 and 100.

Big thanks to Simon Green
for pointing out this <= >= mistake. Your feedback helped improve this article for everyone! 🙌

Comments

[Simon Green]

Great article.

For answer 18, the SQL for the second statement should be quantityInStock >= 10 AND quantityInStock <= 100. The BETWEEN function includes both the start and end values. Being really pedantic, the 20th query shouldn't have lastName in the SELECT clause.

[Jaimin Bariya]

Yes, you are right about answer 18, and I have added lastName for convenience.

[Aaron Reese]

For 12 the answer depends on the dialect of SQL.
In T-SQL (Microsoft) you do select top 10 rather than use the limit keyword
In oracle you have to select top 10 *from (select ... Order by ....) As X

[Nozibul Islam]

thanks for sharing.

[Jaimin Bariya]

.

[1Transcribe]

Good!