Back to Categories

Freshers Interview Questions

50 questions to help you prepare for your next interview.

Aliasing Tables in Joins

Aliasing Columns

Average Grade Score

Basic Arithmetic

Excluding a Genre

Using the BETWEEN Operator

Substituting NULLs with COALESCE

Concatenating Names

Counting Unique Subjects

The COUNT() Function

Difference between DDL and DML

Average Grade per Course

Counting Students by Year

Filtering Groups with HAVING

Using the IN Operator

Measuring Text Length

Pattern Matching (Ends With)

Pattern Matching (Starts With)

Skipping Records with OFFSET

Limiting Results

Multiple Conditions with AND

Multiple Conditions with OR

Formatting Text Case

Simulating Price Adjustments

Halving Course Credits

Finding Even Identifiers

Finding the Newest Movie

The MAX() Function

Finding the Oldest Movie

The MIN() Function

Using the NOT Operator

Ordering Results (Ascending)

Ordering Results (Descending)

Sorting by Multiple Columns

Identify the Foreign Key

Filtering Expensive Orders

Unique Values with DISTINCT

Select Specific Columns

Matching Books with Authors

Sum of Movie Budgets

Inner Join Basics

Write a Subquery

Handling NULL Values

Filtering Orders by Date

Filtering Multiple Genres

Pattern Matching in Titles

Finding Missing Publishers

Filtering with WHERE (Numeric)

Filtering with WHERE (Text)