11 interview questions for developers (2024)

Easy

1 vote527 runs1 comment

Write a SQL query to get the total amount of orders.

Data Scientist

sql

table

Clément Devosat Dec 2, 2021

Expert

0 vote529 runs1 comment

A primary key can be represented on multiple columns.

Data Scientist

primary key

foreign key

Inconnuat Apr 18, 2023

Hard

0 vote501 runs0 comment

SQL query to get the number of orders per customer

Data Scientist

sql

diagram

Clément Devosat Dec 2, 2021

Hard

0 vote495 runs1 comment

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

Data Scientist

sql

notes

Clément Devosat Dec 2, 2021

Easy

0 vote493 runs0 comment

Write a SQL query to get the name of all the employees who are in the sales department.

Data Scientist

sql

join

Inconnuat Dec 2, 2021

Hard

0 vote493 runs0 comment

Write a SQL query to get the number of rows in the table `users`

Data Scientist

sql

join

Clément Devosat Dec 2, 2021

Hard

0 vote491 runs0 comment

Create a new table called notes and insert the notes into the table commande

Data Scientist

sql

database

Clément Devosat Dec 2, 2021

Hard

0 vote489 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

Medium

-1 vote529 runs1 comment

Write a SQL query to get the number of rows in the table `users`.

Data Scientist

sql

joins

Clément Devosat Dec 2, 2021

Medium

-1 vote519 runs0 comment

Can we add a foreign key to the table `users` on the column `id`?

Data Scientist

sql

database

Clément Devosat Dec 2, 2021

Hard

-1 vote498 runs1 comment

Which of the following SQL queries will return the same result? A: SELECT * FROM table WHERE id = 1; B: SELECT * FROM table WHERE id = 1 ORDER BY id;

Data Scientist

sql

join

Clément Devosat Dec 2, 2021

11 interview questionsfor developers (2024)

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

Write a SQL query to get the total amount of orders.

A primary key can be represented on multiple columns.

SQL query to get the number of orders per customer

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

Write a SQL query to get the name of all the employees who are in the sales department.

Write a SQL query to get the number of rows in the table `users`

Create a new table called notes and insert the notes into the table commande

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

Write a SQL query to get the number of rows in the table `users`.

Can we add a foreign key to the table `users` on the column `id`?

Which of the following SQL queries will return the same result? A: SELECT * FROM table WHERE id = 1; B: SELECT * FROM table WHERE id = 1 ORDER BY id;