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;

SOLVE SQL PROBLEMS (TASK # 3 – 6)




Subjects List
Database (48)
Accounting (39)
Economics (34)
Finance (54)
Programming (122)
Management (69)
Marketing (25)
Report Writing (52)
Engineering (79)
Statistics (39)
Business Studies(45)
Case Studies (15)
Networking (26)
UML (9)
Science (23)
Nursing (11)
MATLAB (17)
Psychology (6)
Math (20)
Data Structure (9)
Python (15)
HRM (25)
IT (21)
Computer Science (57)
Law (4)
Essay (3)
Data Analysis (2)
Big Data (3)
Philosophy (2)
History (1)