No products in the cart.

  1. Homework Help
  2. CBSE
  3. Class 12
  4. Computer Science

Consider the following tables GARMENT and …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Install Now
Consider the following tables GARMENT and FABRIC. Write SQL commands for the statements (a) to (d) and give outputs for SQL queries (e) to (h). TABLE: GARMENT GCODEDESRIPTIONPRICEFCODEREADYDATE10023 PENCIL SKIRT1150F0319-DEC-0810001FORMAL SHIRT1250F0112-JAN-0810012INFORMAL SHIRT1550F0206-JUN-0810024BABY TOP750F0307-APR-0710090TULIP SKIRT850F0231-MAR-0710019EVENING GOWN850F0306-JUN-0810009INFORMAL PANT1500F0220-OCT-0810007FORMAL PANT1350F0109-MAR-0810020FROCK850F0409-SEP-0710089SLACKS 750F0320-OCT-08 TABLE: FABRIC  FCODETYPEF04POLYSTERF02COTTONF03SILKF01TERELENE (a) To display GCODE and DESCRIPTION of each GARMENT in descending order of GCODE. (b) To display the details of all the

    • Posted by Sahiba ... 1 year, 7 months ago

    CBSE > Class 12 > Computer Science
    • 0 answers
    ANSWER
    http://mycbseguide.com/examin8/

    Related Questions

    a=[1,12,4,0,18,17,16] n=len(a) for i in range(1,0): key=a[I]: j=i_1 while j>=0 and key

    • Posted by Rada Rada 2 months ago

    CBSE > Class 12 > Computer Science
    • 2 answers
    Write a python program to calculate perimeter of rectangle

    • Posted by Gaya Thri 1 month ago

    CBSE > Class 12 > Computer Science
    • 1 answers
    Whate is global scope

    • Posted by Kathiravan Kathir 2 months, 3 weeks ago

    CBSE > Class 12 > Computer Science
    • 1 answers
    Information technology (code no)pre- broad exam

    • Posted by B.K Bhuyan.18 2 months, 2 weeks ago

    CBSE > Class 12 > Computer Science
    • 0 answers
    This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

    Few rules to keep homework help section safe, clean and informative.
    • Don't post personal information, mobile numbers and other details.
    • Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
    • Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
    • Ask specific question which are clear and concise.

    Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

    Posted by Manoj Kumar Manoj Kumar 2 weeks, 4 days ago

    CBSE > Class 12 > Computer Science
    • 0 answers
    Import math ceil

    • Posted by Ekas Kaur Sachdeva 6 months, 1 week ago

    CBSE > Class 12 > Computer Science
    • 1 answers
    What is the function of def()?

    • Posted by Asmita Bhaumik 3 months, 2 weeks ago

    CBSE > Class 12 > Computer Science
    • 2 answers
    Which of the following mode in file opening statement results or generates an error if the file does not exist?

    • Posted by Twisha Twisha 5 months, 2 weeks ago

    CBSE > Class 12 > Computer Science
    • 2 answers
    Write a program to accept a list of strings, display which as starting and ending letter to be same.

    • Posted by Shakthi Shakthi 1 month, 1 week ago

    CBSE > Class 12 > Computer Science
    • 0 answers
    A Railway company uses machines to sell tickets. The machine details and daily sales information are recorded in two tables: Table Name: Machine Table Name: Sales The primary key of the table Machine is Machine_ID. Records in the table Sales are uniquely identified by the fields Machine_ID and Date. (a) Create the tables Machine and Sales. (b) Write a query to find the number of ticket machines in each station. (c) Write a query to find the total ticket income of the station “New Delhi” of each day. (d) Write a query to find the total number of tickets sold by the machine (Machine_ID = 122) till date.

    • Posted by Parveen Singh 3 weeks, 6 days ago

    CBSE > Class 12 > Computer Science
    • 0 answers

    myCBSEguide App

    myCBSEguide

    Trusted by 1 Crore+ Students

    Install Now

    Test Generator

    Test Generator

    Create papers online. It's FREE.

    Try Now

    CUET Mock Tests

    CUET Mock Tests

    75,000+ questions to practice only on myCBSEguide app

    Install Now
    Google Play

    Download myCBSEguide App

    All Courses

    Other Websites

    CBSE Courses

    Resources

    Corporate

    NCERT Solutions

    CBSE Sample Papers

    All Content and Intellectual Property is under Copyright Protection | myCBSEguide.com ©2007-2024