Devam Ediyor

498076 database

HI

There are 3 files :

first file is printing data: it is the data for all tables

second file: description about the tables.

last file : qustion for My sql and you have to answre it by use sql quere.

for example:

You should write queries to answer the following questions. The queries should be added one at a time (as the previous one is determined to be correct) to a file, printing query .sql.

1. List the names and phone numbers of all customers who have a rush job (jobtype = ‘R').

2. List all items whith a price below the average price of an item.

3. Find the earliest po date for each vendor id

--------------------------------

the answres is:

1- SELECT name , phone

FROM publishers

WHERE cust_id IN (SELECT cust_id

FROM bookjobs

WHERE jobtype = 'R');

2- SELECT *

FROM items

WHERE price < (SELECT AVG(price)FROM items);

3- SELECT vendor_id ,MIN(po_date)

FROM pos

GROUP BY vendor_id;

--------------------------------

note that you have to put this quere in Notepad program and save it for example [url removed, login to view]

==================================

Beceriler: Her şey Kabul, Veri Tabanı Yönetimi, MySQL, SQL

Daha fazlasını görün: bookjobs, average time find job, answer query, sql r, r sql, database vendor, all po, select item, po file, database queries, find average numbers, pos sql, sql pos, phone list names numbers, added database, queries database, numbers database, write sql queries, avg, job notepad, notepad job, list phone numbers names, select name, notepad data file, find last names

İşveren Hakkında:
( 21 değerlendirme ) Adelaide, Australia

Proje NO: #2243993

Seçilen:

ranjitsinha

As discuss.

3 gün içinde 60$ USD
(200 Değerlendirme)
5.7