Question

Using SQL, create a subquery so that the result is the video games whose price is greater than
the avg. video game price in the same genre.

Answer 1

--Please note that the table information for video games is not given
--so I've made the following assumptions regarding the table

--Assumption:
--Table name: video_games
--columns name,genre,price

SELECT vg1.name
FROM video_games as vg1
WHERE price > (select AVG(price)
FROM video_games as vg2
WHERE vg1.genre = vg2.genre)

--here we are making two versions of table video_games vg1,vg2
--since we know that both have same genre
--so we use first version of vg1 genre and second version of vg2
--and write in subquery where clause that both genre are equal
--avg() computes the average

--Hope you got the logic
--let me know if any furthur clarifications in the comment section
--Hit a thumbsUp if the answer was useful