# Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category GME.

### A Guide to SQL

9th Edition
Philip J. Pratt
Publisher: Course Technology Ptr
ISBN: 9781111527273

Chapter
Section

### A Guide to SQL

9th Edition
Philip J. Pratt
Publisher: Course Technology Ptr
ISBN: 9781111527273
Chapter 6, Problem 2TD
Textbook Problem
681 views

## Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table for each item that is not in category GME.

Program Plan Intro

Primary key:

• To identify each record in a table, at least there must be one data field, which should be unique.
• That is corresponding data field of every record should be unique.
• It is called primary key.
• Primary key is used to identify the unique record from a collection of records.

Insert values:

Inserting values comes under Data Manipulation Language (DML).

• The INSERT command in SQL is employed to add records to an existing table.

Syntax for inserting values into the table is as follows:

INSERT INTO TABLE_NAME VALUES('DATA 1', 'DATA 2');

### Explanation of Solution

Inserting values into the table “NONGAME” from the “ITEM” table for each item is not in category of “GME”:

INSERT INTO NONGAME SELECT ITEM_NUM, DESCRIPTION, ON_HAND, CATEGORY, PRICE FROM ITEM WHERE CATEGORY <> 'GME';

Explanation:

• The values are inserted in the table using insert command. The values are inserted as per the condition given in the table creation...

### Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

#### The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Find more solutions based on key concepts
List the two basic knurl patterns.

Precision Machining Technology (MindTap Course List)

What is a typical amperage rating for a residential building?

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

6. How would you level DFDs?

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

A(n) _____ website contains factual material, such as libraries, encyclopedias, dictionaries, directories, guid...

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

Name two advantages of recycling scrap metal.

Welding: Principles and Applications (MindTap Course List)