Find in the payments table the customer_id of customers who have spent (amount) at least $110 with the staff_id who has an ID of 2. You will need to aggregate amount spent.

🎲 Try a Random Question | Total Questions in Quiz: 189 | 🧠 Study this quiz with Flashcards

This question is part of a full practice quiz:

SQL Basics with SQLite and PostgreSQL (Questions) — practice the complete quiz, review flashcards, or try a random question.

🧠 Flashcards (fast review) 🧪 Practice Quiz ⚔️ Challenge a Friend 🥊 📊 View Stats

SQLite is an Embedded DBMS. This means that it is a Serverless DBMS with the ability to run within your applications.

PostgreSQL DBMS implements a Client-Server Model and requires a Database Server to set up and run over a network.

SQLite vs PostgreSQL: SQLite is very fast, thanks to its minimal design and simple operations. SQLite is for you if all you require is fast read operations. PostgreSQL is more suitable for complex operations.

1. Find in the payments table the customer_id of customers who have spent (amount) at least $110 with the staff_id who has an ID of 2. You will need to aggregate amount spent.

sqlite3 mydb.db < my_sql_file.sql
SELECT MAX(downloads) FROM app;
A foreign key is a set of one or more columns in a table that refers to the primary key in another table.
SELECT customer_id,SUM(amount) FROM payment WHERE staff_id = 2 GROUP BY customer_id HAVING SUM(amount) > 110; We select the customer id and the sum of all amounts spent from the payment table. We filter those records to only those in which in the customer interacted with staff member 2. Because what we need is the sum that each customer spent, we need to group transactions by customer_id to get a total amount spent for each customer. Because we want to list only customer id's of customers who have spent at least $110, we filter again, after running the sum function, to list only customers whose total amount spent is greater than $110.

Find in the payments table the customer_id of customers who have spent (amount) at least $110 with the staff_id who has an ID of 2. You will need to aggregate amount spent.

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know?
Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

Find in the payments table the customer_id of customers who have spent (amount) at least $110 with the staff_id who has an ID of 2. You will need to aggregate amount spent.

❤ If you liked Fatskills, consider supporting us by checking out The Life Manuals You Never Got.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know? Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson© 2026 Fatskills.com

All trademarks, logos and brand names are the property of their respective owners. All company, product and service names used in this website are for identification purposes only. Use of these names, trademarks and brands does not imply endorsement.

About | Explore | User Guide | Topics | Subjects | Doubt Solver | Career Aptitude Test | Answers | Free Tools | What Should We Know?
Privacy | Terms |

Without work one finishes nothing. - Ralph Waldo Emerson
© 2026 Fatskills.com