Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is for module 7 use livesql the link is there Thinking Exercise SQL Coding This lab exercise requires that you write your own SQL

This is for module 7 use livesql the link is there

image

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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Understanding Financial Statements

Authors: Lyn Fraser, Aileen Ormiston

11th edition

133874036, 978-0133874037

More Books

Students also viewed these Databases questions

Question

Focus on the interview.

Answered: 1 week ago