Instruction Write a query to count the number of customers who spend more than > $20 by month You can use EXTRACT(YEAR from timestamp_col) and EXTRACT(MONTH from timestamp_col) to get year and month from a timestamp column. Hint: a customer's spend varies every month.

Prev Discuss

Question 9

Number of high spend customers by month

Unsolved Medium Lecture

Premium Access

Unlock this premium interview question.

230+ interview questions
Official solutions
SQL, Python, and R tracks

***********

***** * ***** ** ***** *** ****** ** ********* *** ***** **** **** > $20 ** *****
*** *** *** *******(**** **** *********_***) *** *******(***** **** *********_***) ** *** **** *** ***** **** * ********* ******.
****: * ********'* ***** ****** ***** *****.

Table: payment

***** ****** ******* ************ *****

   ***_****   | ***_****
--------------+--------------------------
 *******_**   | *******
 ********_**  | ********
 *****_**     | ********
 ******_**    | *******
 ******       | *******
 *******_**   | ********* **** **** ****

Sample results

Last Submission

postgres

No submission yet for this engine. Run and submit your query to save it here.

Expected results

Submit a query to compare against expected output.

Engine

Interview timer

Recommended interview pacing

Easy: 5 min for direct warm-up style questions.

Medium: 10 min for multi-step interview queries.

Hard: 15 min for layered questions with tighter time pressure.

A common bar is solving about 2 medium-or-harder questions in a 30 minute interview.

10:00

Timer

Your results

Run your query to preview results here.

More COUNT, SUM, AVERAGE, MIN, MAX, GROUP BY, HAVING Questions

Browse Topic Set

Question	Level	Company	FTPR
#216. Most active customers	Hard	roblox	10%
#215. Monthly active users	Easy	roblox	80%
#214. D30 (30days) retention rate	Medium	roblox	20%
#209. Card issuer customers count	Easy	visa	100%
#207. Results shown rate by group	Medium	apple	50%
#206. Search results recall by testing group	Medium	apple	30%
#205. Search results recall	Medium	apple	30%
#204. AB testing sanity check	Easy	apple	50%
#202. Monthly active paid subscriptions	Hard	apple	50%
#198. Average score per subject	Easy	snap	50%
#197. Students who didn't finish all subjects	Easy	snap	25%
#196. User segments report	Hard	snap	18%
#193. Difference of replies by testing groups	Medium	twitter	33%
#192. Number of replies to the original tweet by group	Medium	twitter	25%
#190. Twitter campaign spend report	Hard	twitter	22%
#187. Comment distribution at Google Forum	Easy	google	17%
#186. Average comments per question	Easy	google	10%
#185. Top 5 non-English contents by watch time	Medium	netflix	49%
#184. Top 5 movies by watch time	Medium	netflix	16%
#183. Top 5 movies by number of watchers	Easy	netflix	46%
#181. Users who watched less than one hour of Netflix	Easy	netflix	19%
#174. Closed accounts	Easy	facebook	23%
#173. User Popularity Percentage	Medium	facebook	11%
#171. Binge watches	Easy	tiktok	19%