Database instance Query

Source: Internet
Author: User


3. Create a table



4. (1) Request the supplier number SnO for J1 parts of the project;


(2) request the supplier number SnO that supplies the J1 part P1 of the project;


(3) request the supplier number SnO whose J1 part is red;


(4) do not use the project No. jno for the red parts produced by the Tianjin supplier;


(5) At least use the project No. jno of all parts supplied by supplier S1.


5. (1) identify the names and cities of all suppliers;


(2) identify the names, colors, and weights of all parts;


(3) Identify the engineering Number of the parts supplied by supplier S1;


(4) identify the names and quantities of various parts used by the Project J2;



(5) Find all part numbers provided by Shanghai manufacturer;


(6) Identify the engineering name of the parts produced in Shanghai;


(7) Find the engineering Number of the parts not produced in Tianjin;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.