I need some queries in MySQL, those queries need to be develop with store procedures and views on the DB, others need to be created with pivot tables, I’ll provide you a backup of the mysql database.
Attached you will find the model of the DB and one query, this query bring me the search about one of parameters what user input.
After the search I need to show the name of Airport from tblAirports and those airports need to be showed like colums not in rows, I need to show the zone from tbl…
