11 interview questions on SQL Data Design for developers (2024)

Expert

1 vote567 runs1 comment

A primary key can be represented on multiple columns.

Data Scientist

primary key

foreign key

Inconnuat Apr 18, 2023

Easy

1 vote564 runs1 comment

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

Data Scientist

sql

table

Clément Devosat Dec 2, 2021

Hard

0 vote540 runs0 comment

SQL query to get the number of orders per customer

Data Scientist

sql

diagram

Clément Devosat Dec 2, 2021

Hard

0 vote536 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 vote534 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 vote534 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 vote531 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 vote529 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 vote586 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 vote561 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 vote537 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 questions on SQL Data Designfor developers (2024)

Test your technical skills before an interview of SQL Data Design with 11 corrected questions. Beginner, Intermediate or Expert level.

A primary key can be represented on multiple columns.

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

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;