logo
+1-617-874-1011 (US)
+61-7-5641-0117 (AU)
+44-117-230-1145 (UK)
Live Chat

SQL assignment question

SQL Scripts to Create Production Table:

CREATE Table Production

(

SerialNo varchar(20) NOT NULL,

BatchNo varchar(25),

ProductCode varchar(25),

MachineTime decimal(2,2),

AssemblyTime decimal(2,2),

FinishTime decimal(2,2),

Cost varchar(20)

);

SELECT

PRODUCTCODE, AVG(MACHINETIME) AS MACHINETIMEAverage, AVG(ASSEMBLYTIME) AS ASSEMBLYTIMEAverage, AVG(FINISHTIME) AS FINISHTIMEAverage ,to_char(AVG(to_NUMBER(SUBSTR(COST,2, LENGTH(COST)-1))), 'L000D000000') AS COSTAverage

FROM PRODUCTION

GROUP BY PRODUCTCODE;

SQL assignment question Image 1

SOLVE SQL PROBLEMS (TASK # 3 – 6)

SQL assignment question Image 2
SQL assignment question Image 3
SQL assignment question Image 4
SQL assignment question Image 5
Improve Your Grades with Custom Writing Help
Homework Help
Writing Help
Editing Services
Plagiarism check
Proofreading services
Research Project help
Custom writing services
scanner
E learning blogs

Disclaimer : The study tools and academic assistance/guidance through online tutoring sessions provided by AssignmentHelp.Net is to help and enable students to compete academically. The website does not provide ghostwriting services and has ZERO TOLERANCE towards misuse of the services. In case any user is found misusing our services, the user's account will be immediately terminated.