This project contains 50 SQL questions and their solutions, prepared using the Oracle HR (Human Resources) database schema. Each question demonstrates both basic and advanced SQL concepts through practical examples.
SQL is the fundamental language for database management and querying. In this project, using the HR database provided by Oracle, 50 hands-on questions were prepared covering topics such as data retrieval, filtering, grouping, subqueries, joins, and nested queries.
Each question is presented with its SQL query, an explanation, and supported with screenshots of the execution results in the Oracle LiveSQL environment.
This repository covers 50 SQL practice questions on the following topics:
✅ SELECT, WHERE, ORDER BY, GROUP BY, HAVING statements
✅ Solutions using JOINS
✅ Subqueries and Nested Queries
✅ Working with NULL values
✅ Aggregate functions: COUNT, SUM, AVG, MIN, MAX
✅ Date and String Functions
All queries in this project were tested on Oracle’s web-based LiveSQL platform:
🔗 Oracle LiveSQL
The project uses Oracle’s sample dataset HR (Human Resources). You can access the script here:
🔗 HR Database Script
git clone https://github.com/bahadirverir/Oracle-SQL-50-Soruda.git