database: sql Q1. Create the following tables:   Carrier   Attribute name Type Size Constraint   carrierID Varchar2 10 Primary key carrierName Varchar2 100 NOT NULL

By using this table answer this question in SQL:   Show the department id, department name and the number of employees working in any department which has less than 4 employees

Write a query in SQL to display all the data of customers, in Table customers, that live in New York or California SELECT city FROM customers WHERE city = 'New York' OR city = 'California' SELECT * FROM customers WHERE city = 'New York' AND city = 'California' SELECT * FROM customers WHERE city = 'New York' OR city = 'California' SELECT ALL FROM customers WHERE city = 'New York' OR city = 'California' %3D

Database https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table) Table Name: Employee EMP_ID             FNAME               LNAME               SALARY         JOIN_DATE              DEP_NO                     101                  John                  Abraham            10000                   01-JAN-13          11             202                  Michael                 Clarke                80000                  01-JAN-13          22            303                       Roy                   Thomas              70000                  01-FEB-13          11             404                     Tom                       Jose                  60000                   01-FEB-13          22             505                        Jerry                    Pinto                 65000                   01-FEB-13               22             606                    Philip                  Mathew              75000…

Use your ERD to define the table structures in the database using SQL DDL commands to build your schema.

In SQL, write the appropriate statements to insert default values ​​for these two tables, each table containing 5 inserts

sql code sql code sql code

Based on the following authorication commands (ordered from 1 to 4), which of the following privileges is true, assuming that Ali is the owner of the database? Order By Ali 1 2 3 4 Select one: Omar Ali Ali Command Grant Select on Employee to Omar with grant option; Grant Select on Employee to Samer with grant option; Grant Update on Employee to Omar with grant option; Revoke Select on Employee From Omar Cascade; a) Ali and Omar have Update privilege on employee Ali has select privilege on employee b) Ali and Omar have Update privilege on employee Omar and Samer have select privilege on employee elect c) Ali and Omar have Update privilege on employee Ali and Omar have select privilege on employee d) Ali and Omar have Update privilege on employee Ali, Omar and Samer have select privilege on employee

Create a Pl SQL package named EMP_PKG which will have the above three functions and procedures as follows:  CALC_TAX - private CHECK_FNAME - Public AVG_SAL - Public