StudyDaddy Article Writing

Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

Jan 07, 2019

CREATE TABLE EMPLOYEE_TABLE ( EMP_ID INT NOT NULL PRIMARY KEY, EMP_LASTNAME VARCHAR2(20 BYTE) NOT NULL UNIQUE, EMP_FIRSTNAME VARCHAR2(20 BYTE) );

Hello I am looking for help on this assignment due in 12 hours. It is as follows.

Individual: SQL Queries

Design and develop the below queries using professional principles and standards:

A set of SQL Statements that returns all rows and all data for each table in your database.
Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause.
Two SQL Statements that join two or more tables in one query. Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries.

Submit a single .sql script file with the statements needed to create the required queries and submit the file using the Assignment Files tab.

I have included my work in an attachment. Also I am using SQL Developer.