Content ITV PRO
This is Itvedant Content department
Study and implement Built-in function of mySQL using Airline reservation data base : Part 2
Business Scenario
Welcome back,Developers!
In the previous lab, we used String Functions to format text and Numeric Functions to perform calculations on airline reservation data.
In this lab, we will explore the remaining two categories of MySQL Built-in Functions—Date Functions and Aggregate Functions—to work with dates, analyze data, and generate meaningful reports.
Pre-Lab Preparation
Git Pull
git pull origin branchNameTopic :
1) Basic SQL Queries
2) Understanding of Built-in functions
Task 1: Use of Date Functions
Display current system date and time.
1
1
Extract year from departure date.
2
1
Display difference between current date and booking date.
3
1
Task 2: Use of Aggregate Functions
Count total number of passengers.
1
1
Find average, minimum, and maximum ticket prices.
2
1
Find total available seats.
3
1
Great job!
You have successfully implemented Date Functions and Aggregate Functions to analyze and summarize airline reservation data.
Checkpoint
git push origin branchNameGit Pull
Next-Lab Preparation
Topic :
1) Basic SQL Queries
2) Basic understanding of Built-in Functions.
3) Understanding of Clauses
Java lab - 25
By Content ITV
