JOINGROUP BY
Return company, title and the number of applications (as applications) for every job post that received at least one application. Sort by applications descending, then title.
Guest mode · solve history stays on this device; code isn’t saved. Sign in to save future work
query.sql
loading editor…
Run your code to see its output, or check your solution to grade it.