Create Table Employee according to your self....and execute these Query..
- SELECT employee_id, last_name, job_id, hire_date FROM employees;
2.Create a query to display unique job codes from the EMPLOYEES table.
SELECT DISTINCT job_id FROM employees;
3.Name the column headings Emp #, Employee, Job, and Hire Date, respectively. Run your query again.
SELECT employee_id "Emp #", last_name "Employee", job_id "Job", hire_date "Hire Date" FROM employees;
4.Display the last name concatenated with the job ID, separated by a comma and space, and name the column Employee and Title.
SELECT last_name||’, ’||job_id "Employee and Title" FROM employees;
5.Create a query to display all the data from the EMPLOYEES table. Separate each column by a comma. Name the column THE_OUTPUT.
SELECT employee_id || ’,’ || first_name || ’,’ || last_name || ’,’ || email || ’,’ || phone_number || ’,’|| job_id || ’,’ || manager_id || ’,’ || hire_date || ’,’ ||
salary || ’,’ || commission_pct || ’,’ || department_id THE_OUTPUT
FROM employees;
Source
Plagiarism is the copying & pasting of others work without giving credit to the original author or artist. Plagiarized posts are considered spam.
Spam is discouraged by the community, and may result in action from the cheetah bot.
More information and tips on sharing content.
If you believe this comment is in error, please contact us in #disputes on Discord
Tushar Sir ,Focuse On Content Writing While Posting