Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 62 (25 poinss) pole t: astamer table CuSno, 6numeric CUSTLNAME, 15 charatters CUSTRNAME. 15 chanacters CUSTSTREET, SO charDiters CUSTSTATE, 2 churacters CUSTZP. 5 numenic

image text in transcribed
Question 62 (25 poinss) pole t: astamer table CuSno, 6numeric CUSTLNAME, 15 charatters CUSTRNAME. 15 chanacters CUSTSTREET, SO charDiters CUSTSTATE, 2 churacters CUSTZP. 5 numenic TAEC 2- PROOUCT Toble PROOD, 8 numenic PROONAME, 18 characters PROOOESCRIPIION, 45 characters PROOVENDOR, 20 characters Whic the 5Q statement to 1. Create EACH bable 2. Add two rons of data brou make it up into EACH table. 3. Setct rous from Table 1 where zipcode is equal to 30000 4. Sotct rows from Table f where customer last name is "lones" 5. Selcat rows from Table 2 where product id is greater than or equal fo 35590788 6. Select rows from Table 2where product vendori nor "Federated Foods

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Databases questions