Skip to content
Advertisement

Finding the most active video maker within multiple tables(SQLite)

How can I find the initials of the most active video maker, the one that made the most videos considering the following tables using only one query?

NOTE: It is guaranteed that there will be only one video_maker who has contributed to a maximum number of news items. For this problem, foreign_keys is ON

Advertisement

Answer

You can get the name of the video maker who made the most videos with this query:

and to get the initials you must use it as a subquery in the WHERE clause:

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement