Job offersCompaniesTestsBlogI'm an employerSign upLog in
Home>IT Tests>Questions>Write a SQL query to get the total amount of orders for each customer.

Question from the SQL Data Design test

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

Hard

THIS BLOCK IS THE SAME FOR ALL QUESTIONS

You must design a landscaper marketplace.

A person can register as a landscaper. She then chooses the services she offers from a pre-established list. She then declares - by selecting on a calendar - her availability (a start date and an end date, the days are always whole).

Another person can register on the site as a client. She can then select the service or services she is looking for. A list of landscapers is then presented to her with a filter that allows only landscapers available for certain days / periods to be presented.

If the client finds an adequate landscaper, he can then select the dates he actually needs and then place an order.

All quiz questions refer to this problem.

####Two important constraints are added to answer the questions:

No data redundancy is tolerated.

We will consider the storage of structured data (table, hash, json, etc.) in a single data field impossible.

After the delivery of each order, the client can now leave a rating of 1 to 5 regarding the landscaper.

For what good reasons could we choose diagram A compared to diagram B?

Author: Clément DevosStatus: PublishedQuestion passed 570 times
Edit
0
Community EvaluationsNo one has reviewed this question yet, be the first!
Similar Questions
0
Write a SQL query to get the number of rows in the table `users`
1
A primary key can be represented on multiple columns.
0
Create a new table called notes and insert the notes into the table commande
0
Write a SQL query to get the average of the number of orders per customer.
0
SQL query to get the number of orders per customer
1
Write a SQL query to get the total amount of orders.
1
Write a SQL query to get the name of all the employees who are in the sales department.