mga boss baka may makatulong sakin
Create the SQL command for the below problems; use the table below for the instance of the database.
DB Name: Company_ABC
DB Table: Employee
SQL command to create database Company_ABC.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to create table Employee.
__________________________________________________________________________________________________
__________________________________________________________________________________________________
__________________________________________________________________________________________________
__________________________________________________________________________________________________
__________________________________________________________________________________________________
____________________
SQL command to insert employee 1.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to insert employee 2.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to insert employee 3.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to insert employee 4.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to get the sum of basic pay of all employees.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to count all male employees residing at San Pablo City.
__________________________________________________________________________________________________
________________________________________________________________________
Application
Create the SQL command for the below problems; use the table below for the instance of the database.
DB Name: Company_ABC
D
Create the SQL command for the below problems; use the table below for the instance of the database.
DB Name: Company_ABC
DB Table: Employee
EMP_id | EMP_name | EMP_sex | EMP_add | EMP_byear | EMP_hdate | EMP_basicpay | ||
San Pablo | ||||||||
1 | John | M | City | 1990 | 2009 | 25000 | ||
San Pablo | ||||||||
2 | Eve | F | City | 1994 | 2011 | 24000 | ||
3 | Matt | M | Calamba City | 1992 | 2005 | 30000 | ||
4 | Mary | F | Calamba City | 1987 | 2002 | 35000 | ||
__________________________________________________________________________________________________
________________________________________________________________________
107
SQL command to create table Employee.
__________________________________________________________________________________________________
__________________________________________________________________________________________________
__________________________________________________________________________________________________
__________________________________________________________________________________________________
__________________________________________________________________________________________________
____________________
SQL command to insert employee 1.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to insert employee 2.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to insert employee 3.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to insert employee 4.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to get the sum of basic pay of all employees.
__________________________________________________________________________________________________
________________________________________________________________________
SQL command to count all male employees residing at San Pablo City.
__________________________________________________________________________________________________
________________________________________________________________________
Application
Create the SQL command for the below problems; use the table below for the instance of the database.
DB Name: Company_ABC
D