Write SQL statements for the following: a. Retrieve all partNumber and partDescription columns from a Parts table

Question:

Write SQL statements for the following:

a. Retrieve all partNumber and partDescription columns from a Parts table that has 15 different columns.

b. Retrieve records from a Parts table for partNumbers 1000 through 2000.

Display the partDescription only.

c. Insert a new record into a Customer table. Store the following values in the columns: LName=Osprey, FName=Teola, CNumber=23456. The columns are ordered as follows: CNumber, LName, FName.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Answer rating: 100% (QA)

Answered By

JAPHETH KOGEI

Hi there. I'm here to assist you to score the highest marks on your assignments and homework. My areas of specialisation are: Auditing, Financial Accounting, Macroeconomics, Monetary-economics, Business-administration, Advanced-accounting, Corporate Finance, Professional-accounting-ethics, Corporate governance, Financial-risk-analysis, Financial-budgeting, Corporate-social-responsibility, Statistics, Business management, logic, Critical thinking, So, I look forward to helping you solve your academic problem. I enjoy teaching and tutoring university and high school students. During my free time, I also read books on motivation, leadership, comedy, emotional intelligence, critical thinking, nature, human nature, innovation, persuasion, performance, negotiations, goals, power, time management, wealth, debates, sales, and finance. Additionally, I am a panellist on an FM radio program on Sunday mornings where we discuss current affairs. I travel three times a year either to the USA, Europe and around Africa. As a university student in the USA, I enjoyed interacting with people from different cultures and ethnic groups. Together with friends, we travelled widely in the USA and in Europe (UK, France, Denmark, Germany, Turkey, etc). So, I look forward to tutoring you. I believe that it will be exciting to meet them.

3.00+ 2+ Reviews 10+ Question Solved

Related Book For book-img-for-question