47 interview questions for developers (2026)

Easy

55 votes3790 runs0 comment

Write a SQL query to retrieve the list of employees with a salary greater than 5100.

Back-end developer

sql

select

where

Anonymous authorat Mar 30, 2023

Easy

21 votes3751 runs0 comment

Write a SQL query to insert data into a table

Back-end developer

sql

insert

Anonymous authorat Mar 27, 2023

Easy

21 votes3737 runs0 comment

Select only distinct values in a column using SQL

Back-end developer

sql

distinct

Anonymous authorat Mar 27, 2023

Easy

19 votes3641 runs1 comment

Update a column in an SQL table

Back-end developer

sql

update

Anonymous authorat Nov 7, 2023

Easy

17 votes3713 runs0 comment

Which SQL keyword is used to sort the result of a SELECT statement?

Back-end developer

sql

order by

Anonymous authorat Mar 27, 2023

Medium

14 votes3680 runs4 comments

Write the SQL query to delete a column from a table

Back-end developer

sql

table

column

Anonymous authorat Mar 27, 2023

Easy

11 votes3648 runs0 comment

How to delete an SQL table?

Back-end developer

sql

tables

Anonymous authorat Mar 27, 2023

Easy

11 votes3628 runs0 comment

Count the number of rows in an SQL table

Back-end developer

sql

count

Anonymous authorat Mar 27, 2023

Easy

11 votes3536 runs0 comment

Write a SQL query to retrieve the products with a price less than 1000 and sort the results in descending order of price.

Back-end developer

sql

order by

descending

Anonymous authorat Mar 28, 2023

Easy

10 votes3537 runs

2 comments

Write a SQL query to increase the salary of all employees by 10%.

Back-end developer

sql

update

salary

Anonymous authorat Mar 28, 2023

Easy

9 votes3715 runs

5 comments

Write an INNER JOIN query in SQL

Back-end developer

sql

join

Anonymous authorat Mar 27, 2023

Medium

9 votes3097 runs2 comments

Write a SQL query to get the order_id and total number of items for each order.

Back-end developer

sql

join

group by

Anonymous authorat Jan 2, 2024

Easy

8 votes3460 runs0 comment

Write a SQL query to get the total order amount for each customer.

Back-end developer

sql

sum

group by

Anonymous authorat Mar 28, 2023

Easy

8 votes3219 runs1 comment

Write a SQL query to retrieve employees with a salary higher than the average salary.

Back-end developer

sql

average

select

Anonymous authorat Mar 28, 2023

Easy

6 votes3541 runs0 comment

Write a SQL query to calculate the total quantities sold for each product_id.

Back-end developer

sql

sum

group by

Anonymous authorat Mar 28, 2023

Easy

6 votes1141 runs0 comment

Write a SQL query to get the total sales quantity for each product.

Back-end developer

sql

sum

group by

JOHANat Jul 19, 2024

Easy

5 votes3658 runs

9 comments

Which SQL keyword is used to filter the results of a SELECT statement based on a specified condition?

Back-end developer

sql

select

where

Anonymous authorat Mar 27, 2023

Easy

4 votes1115 runs1 comment

Write the SQL code to create a table with a primary key

Back-end developer

sql

primary key

Anonymous authorat Nov 15, 2023

Easy

3 votes772 runs0 comment

Which SQL command allows you to define a constraint on the range of values of a column when creating a table?

Back-end developer

sql

constraints

Louis Prevosteauat May 15, 2023

Hard

3 votes692 runs0 comment

Write a SQL query to get the average of the number of orders per customer.

Data Scientist

sql

error

Clément Devosat Dec 2, 2021

47 interview questionsfor developers (2026)

Test your developer skills before an interview with 47 corrected questions on 80+ topics. Beginner, Intermediate or Expert level.

Write a SQL query to retrieve the list of employees with a salary greater than 5100.

Write a SQL query to insert data into a table

Select only distinct values in a column using SQL

Update a column in an SQL table

Which SQL keyword is used to sort the result of a SELECT statement?

Write the SQL query to delete a column from a table

How to delete an SQL table?

Count the number of rows in an SQL table

Write a SQL query to retrieve the products with a price less than 1000 and sort the results in descending order of price.

Write a SQL query to increase the salary of all employees by 10%.

Write an INNER JOIN query in SQL

Write a SQL query to get the order_id and total number of items for each order.

Write a SQL query to get the total order amount for each customer.

Write a SQL query to retrieve employees with a salary higher than the average salary.

Write a SQL query to calculate the total quantities sold for each product_id.

Write a SQL query to get the total sales quantity for each product.

Which SQL keyword is used to filter the results of a SELECT statement based on a specified condition?

Write the SQL code to create a table with a primary key

Which SQL command allows you to define a constraint on the range of values of a column when creating a table?

Write a SQL query to get the average of the number of orders per customer.