Question: Using SQL command to complete the following tasks: Which commands would be used to accomplish these tasks? 1. Select the supplier number and

Using SQL command to complete the following tasks: 

 

Which commands would be used to accomplish these tasks? 

 

1. Select the supplier number and name from SUPPLIER table.

 

2. View the different/distinct SUPNR from PURCHASE_ORDER table.

 

3. In Supplies table, show supplier number, product number and delivery period in weeks. (Note, currently the delivery period unit is day)

 

4. Find the product number and name of all products staring with the string 'Me' as the start of their product names.

 

5. View SUPNR, PONR, PODATE from PURCHASE_ORDER table and order the retrieved records in ascending order on PONR field.

 

6. Insert a new product record with number of '1002', name of 'Leeuwin Estate Cabernet Sauvignon 2011', type of 'white', and quantity of 20.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 To select the supplier number and name from the supplier table use the SELECT statement SELECT Sup... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure...

Q:

The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in...

Q:

In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25 in Chapter 1. (If you use a computer to complete these exercises, use a...

Q:

home / study / engineering / computer science / computer science questions and answers / task notes this assignment requires you to use sqlite to complete the tasks listed below.student ... Question:...

Q:

Task NOTES This assignment requires you to use SQLite to complete the tasks listed below.Student can also use SQL Workbench or another software (if they are familiar) to complete the tasks. For...

Q:

Use SQL Developer to execute SQL statements to complete the following tasks: 1. Create an index on the employee Last Name column of the employee table. 2. Create an index on the combination of Last...

Q:

From Resources under Main Menu in Interact 2 go to Assignment 5 Folder Copy sqlite3.exe file from the Assignment 5 Folder into a folder in your machine Copy a5.txt from the Assignment 5 Folder into...

Q:

Search for files The grep and find commands many options for filtering and finding exactly the information you need, including content, owner, permissions, dates, etc. Filter log files The grep...

Q:

PLEASE USE TERMINAL AND EXPLAIN STEPS Write a program that uses a random number generator to generate a three-digit integer that allows the user to perform the following operations: - Sum the digits...

Q:

As you have experienced, relationships between different database tables are a very common way of organizing data in a relational database system. In this last set of challenges, youll be working...

Q:

You have been given the following monthly data: Company ai ( iuntercept ) \ sigma i riM Pickled Fish 0 . 2 4 0 1 3 . 3 0 % 0 . 7 1 0 S&P 5 0 0 0 . 0 0 0 5 . 0 0 % 1 . 0 0 0 Assuming a risk - free...

Q:

Case: Mumbai Dabbawalas (https://www.youtube.com/watch?v=Tds9Y4KIUKk) Then write short notes on the following Mission; Organisation; Management; Process; Culture; Distinctive Competence; Objectives...

Q:

Link: https://www.npr.org/2021/01/08/954760928/twitter-bans-president-trump-citing-risk-of-further-incitement-of-violence Please refer to the article (and events described within) linked above.After...

Q:

Watch the video " Salary Negotiations " on viddler.com. This video opens by citing a Salary.com statistic that predicts you could have lost out on $500,000 in salary by the age of 60 if you do not...

Q:

4) E-Mart Stores uses people and computerized scanners to add arriving shipments into its inventory and to deduct units sold from its inventory. E-Mart's production function is Q = KL, where Q...

Q:

A client would like to quit smoking, so the therapist suggests hypnosis. The client undergoes hypnosis and finds that it does help. Which state of consciousness was the client in during the hypnosis?...

Q:

A journal entry would need to be made for which of the following adjustments on a bank reconciliation? O A. Bank service charges OB. Deposits in transit O c. Bank error to be corrected by the bank...

Q:

What are the key elements of a system investigation report?

Q:

What are two disadvantages of updating replicated data in a distributed database?

Q:

What is the difference between a file server and a client/server system?

Q:

Describe the purpose of the PROJECT command in relational algebra.

Q:

The owner of a property listed at $145,000 is considering two offers. Offer C is for $140,000 cash. Offer M is for $50,000 cash and a mortgage back to the vendor for $100,000 at a rate of 8%...

Q:

A favorite summer pastime for many Americans is camping. In fact, camping has become so popular at the California beaches that reservations must sometimes be made months in advance! Data from a USA...

Q:

A marketing innovation is the cash-back mortgage wherein the lender gives the borrower an up-front bonus cash payment. For example, if you borrow $100,000 on a 3% cash-back mortgage loan, the lender...