🔒 Closed Pa help po sa mga boss

[Hyper24]

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

	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​

SQL command to create database Company_ABC.
__________________________________________________________________________________________________
________________________________________________________________________

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

 

[dark_cloud]

this... is going to be another mediocre IT graduate in the future.

 

[Kilaaa]

Hello TS! Try to search muna ng mga commands sa sql. You need to explore first and try. Marami jan sa internet na mga tutorials galaw galaw din pag may time hehehe.