This is for module 7 use livesql the link is there Thinking Exercise SQL Coding This lab

This is for module 7 use livesql the link is there

Transcribed Image Text:

Thinking Exercise SQL Coding This lab exercise requires that you write your own SQL code. The information that you will require can be found in the recording of the previous class session., CHThis assignment is an assessment to determine that you can write SQL code in a real-world situation. All queries must work and yield a return of data. Please pro screenshot of the code and the data that the code yields. Visit the following website: https://livesql.oracle.com/a ex/f?p=590:1000:0 1. Load the database from the script named: Ch07_AviaCo_ORA.txt. You will find this file under course documents in Canvas. 2. Write an SQL query using the AND operator that will return a result in which the charter hour wait time is greater than 3 and the customer code is 10011. You will find the data in the Charter table 3. Write an SQL query using the OR operator that will return a result in which the charter hour wait time is greater than 3 or the customer code is 10011. You will find the data in the Charter table 4. Write an SQL query using the IN operator to show customer codes 10011, 10014 & 10019. This query will show only the charter trip, charter date and customer code. You will find the data in the Charter table 5. Write an SQL query using the between operator to show all charter trips with a distance between 500 and 1000 miles. This query must also show the charter trip and charter date. You will find the data in the Charter table 6. Use the not operator to exclude all model codes of PA23-250 from the Aircraft table. 7. Write an SQL Query using the LIKE and '%' wildcard operator to show all Customers with a Customer Name beginning with the letter F. Use the Customer table. 8. Write an SQL query using a comparison operator that will display all customer with a balance of more than 500. This query must also display the customer code and the customer's first and last names. Thinking Exercise SQL Coding This lab exercise requires that you write your own SQL code. The information that you will require can be found in the recording of the previous class session., CHThis assignment is an assessment to determine that you can write SQL code in a real-world situation. All queries must work and yield a return of data. Please pro screenshot of the code and the data that the code yields. Visit the following website: https://livesql.oracle.com/a ex/f?p=590:1000:0 1. Load the database from the script named: Ch07_AviaCo_ORA.txt. You will find this file under course documents in Canvas. 2. Write an SQL query using the AND operator that will return a result in which the charter hour wait time is greater than 3 and the customer code is 10011. You will find the data in the Charter table 3. Write an SQL query using the OR operator that will return a result in which the charter hour wait time is greater than 3 or the customer code is 10011. You will find the data in the Charter table 4. Write an SQL query using the IN operator to show customer codes 10011, 10014 & 10019. This query will show only the charter trip, charter date and customer code. You will find the data in the Charter table 5. Write an SQL query using the between operator to show all charter trips with a distance between 500 and 1000 miles. This query must also show the charter trip and charter date. You will find the data in the Charter table 6. Use the not operator to exclude all model codes of PA23-250 from the Aircraft table. 7. Write an SQL Query using the LIKE and '%' wildcard operator to show all Customers with a Customer Name beginning with the letter F. Use the Customer table. 8. Write an SQL query using a comparison operator that will display all customer with a balance of more than 500. This query must also display the customer code and the customer's first and last names.