How to create a nested select query as a new table in SQL

QuestionsHow to create a nested select query as a new table in SQL
sethbeckerman5 Staff asked 4 years ago

I have a problem about writing a nested Select queries in sql.
I tried to devise a new table to show their counts of the tables but I couldn't complete the rest part. I show it as "…."
How can I do that?
Here is the code snippet shown below.

I want to get this result


View on Stack Overflow