Apalachia hwy apt phoenix goscreenshot executed code select from employeeresult query
Here is sql code for creating table Employee
/***********Employee table creation sql code ***********************/
[emp_address] [nvarchar](250) NULL,
[emp_city] [nvarchar](50) NULL,
[emp_gender] [nvarchar](10) NULL,
[dob] [date] NULL,
[emp_salary] [nvarchar](50)NULL,
[job_id] [nvarchar](50) NOT NULL,
) ON [PRIMARY]
GO
/***********inserting 1 row data***************/
USE [OGIEDATABASE]
,[emp_fname]
,[emp_address]
,[emp_phn]
,[emp_gender]
,[emp_marriagestatus]
,[emp_salary]
/***********inserting 2 row data***************/
USE [OGIEDATABASE]
,[emp_fname]
,[emp_address]
,[emp_phn]
,[emp_gender]
,[emp_marriagestatus]
,[emp_salary]
/***********inserting 3 row data***************/
USE [OGIEDATABASE]
,[emp_fname]
,[emp_address]
,[emp_phn]
,[emp_gender]
,[emp_marriagestatus]
,[emp_salary]
/***********inserting 4 row data***************/
USE [OGIEDATABASE]
,[emp_fname]
,[emp_address]
,[emp_phn]
,[emp_gender]
,[emp_marriagestatus]
,[emp_salary]
/***********inserting 5 row data***************/
USE [OGIEDATABASE]
,[emp_fname]
,[emp_address]
,[emp_phn]
,[emp_gender]
,[emp_marriagestatus]
,[emp_salary]
/***********inserting 6 row data***************/
USE [OGIEDATABASE]
,[emp_fname]
,[emp_address]
,[emp_phn]
,[emp_gender]
,[emp_marriagestatus]
,[emp_salary]
/***********inserting 6 row data***************/
USE [OGIEDATABASE]
,[emp_fname]
,[emp_address]
,[emp_phn]
,[emp_gender]
,[emp_marriagestatus]
,[emp_salary]
Screenshot of executed code
Write a query, that shows the employee's name in one column, entitled "Full Name" in the following format - Bob Smith.
Answer: select emp_fname + ' '+ emp_lname As Full_Name from employees
Twila Thompson
Sara Sanderson
Select * from Job_title
Result:
J5 SENIOR Manager Hr manager job open
Screenshot
Result:
Join two tables in the example database and use LIKE to restrict the records based on Telephone Area Codes. Take a screenshot of the executed code and the results.
Answer:
select * from employees where emp_fname like ('_a%' ) or emp_fname like ('_e%' )or emp_fname like ('_o%' )or emp_fname like ('_u%' )
Result: