Kizspy | Question: 67
(Choose 1 answer)
What does the following line of code do in postgres?
SELECT count(userid) FROM (SELECT buyclicks.userld, teamLevel, price FROM buyclicks JOIN gameclicks on buyclicks.userld = gameclicks.userld) temp WHERE price=3 and teamLevel=5;
A. Displays the users who have bought items worth $3 and have had a team with level 5.
B. This is an invalid line of code, the subquery is not formatted properly.
C. Counts the users who exists between both gameclicks and buyclicks files.
D. Finds the total number of user ids (repeats allowed) in buy-clicks that have bought items with prices worth $3 and was in a team with level 5 at some point in time.
