Java, Spring Boot, and DB Basics | Dataford Interview Questions

How would you answer basic Java, Spring Boot, and database questions in an interview?

You are given a small log of interview questions and the topic each question belongs to. Write a SQL query that returns the number of questions in each topic category.

Output

One row per topic category
Columns: topic, question_count
Include only rows where topic is not null
Sort by question_count descending, then topic ascending

Schema

interview_questions

Column	Type	Description
question_idPK	INT	Unique identifier for the interview question
topic	VARCHAR(50)	Topic category for the question, such as Java, Spring Boot, or database
question_text	VARCHAR(255)	Interview question text
asked_by_team	VARCHAR(50)	Team that asked the question

Your question is Java, Spring Boot, and DB Basics. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem