BDI302cXuất hiện trong 1 đề thi
What does the following line of code do in postgres? \nsql\nSELECT count(userid)\nFROM ( SELECT buyclicks.userId, teamLevel, price FROM buyclicks JOIN gameclicks ON buyclicks.userId = gameclicks.userId ) temp\nWHERE price=3 and teamLevel=5;
Các lựa chọn
ADisplays the users who have bought items worth $3 and have had a team with level 5.
BThis is an invalid line of code, the subquery is not formatted properly.
CCounts the users who exists between both gameclicks and buyclicks files.
DFinds 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.