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
