1. SQL Exercise a) Write the SQL Command [//WRITE CODE HERE] name, salary, department [//WRITE CODE HERE] employees_table [//WRITE CODE HERE] start_date >= "2019-01-01"; b) The table and following SQL command will result in how many rows? Invoices Invoice id date amount 001-8 2019-10-02 35000 001-9 2019-10-02 47000 001-10 2019-10-03 23000 001-11 2019-10-04 10000 SQL SELECT * FROM invoices WHERE invoice_id < "001-10"; a. 0 rows b. 1 row c. 2 rows d. 3 rows c) The following table and SQL command will result in how many rows? catalogs item sale_price Full_price 25 Apple NULL Pizza NULL NULL Cake 120 90 Juice 45 45 SQL SELECT * FROM catalogs WHERE sale_price IS NULL; a. 1 row b. 2 rows c. 3 rows d. 4 rows

1. SQL Exercise a) Write the SQL Command [//WRITE CODE HERE] name, salary, department [//WRITE CODE HERE] employees_table [//WRITE CODE HERE] start_date >= "2019-01-01"; b) The table and following SQL command will result in how many rows? Invoices Invoice id date amount 001-8 2019-10-02 35000 001-9 2019-10-02 47000 001-10 2019-10-03 23000 001-11 2019-10-04 10000 SQL SELECT * FROM invoices WHERE invoice_id < "001-10"; a. 0 rows b. 1 row c. 2 rows d. 3 rows c) The following table and SQL command will result in how many rows? catalogs item sale_price Full_price 25 Apple NULL Pizza NULL NULL Cake 120 90 Juice 45 45 SQL SELECT * FROM catalogs WHERE sale_price IS NULL; a. 1 row b. 2 rows c. 3 rows d. 4 rows

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: SQL code for (see image for the table structure): Create a stored procedure “changeCreditLimit” to…

A: The solution is an given below :

Q: Our salesperson made a mistake when placing the order with Id = 830. Several incorrect products were…

A: Ans:) Here we have given a list of productId and productName and we have to delete the orders from…

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: We have employee table contains (emp-no, emp-name, emp-age, emp-salary, emp-department) write a…

A: Given Employee table contains the attributes: emp_no, emp_name, emp_age, emp_salary, emp_department

Q: orms Addition, Subtraction Mu

A: SQL (Structured Query Language) is a domain-specific language used for managing and manipulating…

Q: Write three functions in SQL which does the following: The first function should take an integer…

A: In MYSQL function Syntax to convert number from one base to another follows:- CONV(<num to…

Q: Write PL/SQL or T-SQL procedures to accomplish the following tasks: A: obtain the name and credit…

A: Actually, SQL stands for Structured Query Language.

Q: Students Table : • List of all Students, just FirstName, LastName and gpa, with a C avg(2.0 to…

A: ANSWER: Student Table: Syntax of SQL Table Statement

Q: In the preceding PL/SQL block, determine the values and data types for each of the following cases.…

A: PL/SQL block, the values and data types for each of the following cases are: a) The value of…

Q: Write a function and a call program in PL/SQL to sum the even integers between 1 and any number that…

A: given to write pl/sqlprocedure function for sum of 1 to n even numbers: Below is the procedure of…

Q: Translate the following SQL query to a pandas statement in Python so that it can be executed on the…

A: count(*)-count number of rows satisfying the condition sqldta-table name conditions;- case>1000…

Q: The given SQL creates a Song table and inserts three songs. Write three UPDATE statements to make…

A: Solution - (Note: all data used in this solution is dummy.) Song table at starting - Task 1:…

Q: Imagine that you are a database manager at a company that makes custom shirts. One column in the…

A: Create the sample table shirts having columns idshirt as integer and autoincremented, wholesaleprice…

Q: plz fix the following so it runs on sql developper or sql live CREATE TABLE DONORS ( donor_id INT…

A: Need to fix the given query :CREATE TABLE DONORS (donor_id INT NOT NULL,donor_name varchar(255) NOT…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

Kindly do all the parts of the given sql questions

1. SQL Exercise
a) Write the SQL Command
[//WRITE CODE HERE] name, salary, department
[//WRITE CODE HERE] employees_table
[//WRITE CODE HERE] start_date >= "2019-01-01";
b) The table and following SQL command will result in how many rows?
Invoices
Invoice_id
date
amount
001-8
2019-10-02
35000
001-9
2019-10-02
47000
001-10
2019-10-03
23000
001-11
2019-10-04
10000
SQL
SELECT *
FROM invoices
WHERE invoice_id < "001-10";
a. 0 rows
b. 1 row
C. 2 rows
d. 3 rows
c) The following table and SQL command will result in how many rows?
catalogs
item
Full_price
sale_price
Apple
25
NULL
Pizza
NULL
NULL
Cake
120
90
Juice
45
45
SQL
SELECT *
FROM catalogs
WHERE sale_price IS NULL;
a. 1 row
b. 2 rows
c. 3 rows
d. 4 rows

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step 3

VIEW

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Is this statement true or false: Oracle SQL allows full expression-based use of both provided (built-in) and user-definable functions.
i amm trying to do some work in sql developer insert data from nametest to names i want only to insert year ,name and gender ,then create a id for each data in the databse . what commend shouldi use ? i try "INSERT INTO names(Year, Name, gender),SELECT (Year_, name_, genderA) FROM namestest; it shows Error starting at line : 1 in command -INSERT INTO names(Year, Name, gender),SELECT (Year_, name_, genderA) FROM namestestError at Command Line : 2 Column : 21Error report -SQL Error: ORA-00926: missing VALUES keyword00926. 00000 - "missing VALUES keyword"*Cause: how to make it corrrect ?and make a "id "for each data ?
I use the My SQL Workbench ,this question is for My SQL class ,can you provide me the solution using the My SQL workbench ?
This is for SQL Give me a list of all of our vendors (by their name) and, if they have an invoice, give me the total number of invoices we have from them and the invoice date of their first invoice. The invoice date results should be provided in a way that shows the date only in the following format: mm/dd/yyyy (e.g. 10/04/2021)
In what scenarios is the CAST function preferred over CONVERT in SQL for type conversion?
Hello! I was given those tables(no data) and I am supossed to write sql code for the following. But I looks like I have a syntax error or there is something I have wrote wrong. (see images) (1) Create a trigger “insert_inventory” on table “Inventory”. The trigger is fired after a row is inserted in table “Inventory”. After a row is inserted in table “inventory”, the “itemid”, the insertion time, and the action is inserted in table “Inventory_history”. The action is set to ‘add an item’. The oldprice is set to null. Test your trigger by inserting a row into Inventory and displaying the contents of Inventory_history. (3) Create a trigger “change_price” on table “Inventory”. The trigger is fired before a change is made to the “Inventory” table. Before the price of an item is changed, the “itemid”, the item’s old price, the action, and the time of change are inserted into the table “Inventory_history”. The action is set to “price change”. Test your trigger by updating a row in Inventory…