i need help with these examplesin database Assuming that this query displays the Employees whose first name starts with letter A, whichcondition should be added to make it true ?Select Lname || fname as name , salary from employee wherea. Instr(fname,'A') = 0 ;O b. Instr(fname,'A') = 1 ;c. Initcap(fname) Like 'a%' ;O d. Fname Like '_A%' ; Which command is used to add new column (Budget) to project table where the budget must notexceed 200000$?a. Alter table project add column (budget number not null);O b. Alter table project add (budget number not null >200000);C. Alter table project add (budget number check(budget < 200000));O d. Alter project add column (budget <200000);

Since we can answer only up to 1 question. So we'll answer the first question. Please resubmit the…

Assuming that this query displays the Employees whose first name starts with letter A, which condition should be added to make it true ? Select Lname || fname as name , salary from employee where a. Instr(fname,'A') = 0; b. Instr(fname,'A') = 1; c. Initcap(fname) Like 'a%' ; d. Fname Like'_A%' ;

Assuming that this query displays the Employees whose first name starts with letter A, which condition should be added to make it true ? Select Lname || fname as name , salary from employee where a. Instr(fname,'A') = 0; b. Instr(fname,'A') = 1; c. Initcap(fname) Like 'a%' ; d. Fname Like'_A%' ;

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter8: Advanced Sql

Section: Chapter Questions

Problem 59P

See similar textbooks

Related questions

Q: The query that displays names of employees , sex , and evaluation of the salary for each department…

A: SELECT AVG(salary) /*incorrect*/ FROM EMPLOYEE, DEPENDENT /* a salary is included once */ WHERE…

Q: The following query reports the highest bonus amount of all employees by year and job code. Complete…

A: SQL

Q: The Binder Prime Company wants to recognize the employee who sold the most of its products during a…

A: We need to provide a query to display the employee number, employee first name, employee last name,…

Q: You need to find out the names of all employees who belong to the same department as the employee…

A: Before solving the answer lets clearly understand the question:- There are two tables employee and…

Q: Based on the following SQL statement: SELECT acct_id, balance FROM Account WHERE balance < 0 AND…

Q: ELECT Rating FROM Professor P1 VHERE 5>= (SELECT COUNT(*) FROM Professor P2 WHERE P1.Rating…

A: Introduction :

Q: Now write a query which make use of equijoin to display the output as follows: Output Amani CS306…

A: I have provided a solution in step2.

Q: Employee_id Name Salary 1001 Annie 6000 1009…

A: SELECT * FROM employee WHERE employee_id>1009 employee_id will be 1018 And output will be…

Q: The query that displays birth date of employee whose ssn = 123456789 in format 'Saturday…

A: to_char() is used to format output in specified format Day Month/dd/Year is the format to get…

Q: Q2/ The difference between the results of executing the following two SQL queries: Select…

Q: 6) Which query will output the table contents when the value of C_PRICE is not equal to 777? a.…

A: To do comparisons between two expressions, like equal, greater than, less than, greater than or…

Q: Write a SQL query that selects OrderID and OrderDate from the Orders table and OrderDetailID from…

A: Introduction: A JOIN clause is used to merge data from more than "2" tables based on a standard…

Q: Describe a situation in which you would need to write a query using the HAVING clause.

A: Consider a situation in which the database administrator needs to group the table column or…

Q: Each month, a customer needs to pay whichever amount is smaller: the account balance or the minimum…

A: Each month, a customer needs to pay whichever amount is smaller: the account balance or the minimum…

Q: Write a query to produce the total number of hours round to 1 digit and charges round to 2 digits…

A: The Sql Query corresponding to the above problem is solved as : SELECT Proj_Num,…

Q: 1. Write a query that displays the employee number and last name of all employees who work in a…

A: Here is the answer:-

Q: Write a query to display the number of people with the same job. JOB ID COUNT() AC_ACCOUNT AC_MGR AD…

A: Here, we have to group the employees based on the job_id and then count the number of employees in…

Q: Write a query to fetch details of employees whose Last_Name ends with an alphabet ‘A’ and contains…

A: In this question, first i need to create a employee table which must contain first and last name and…

Q: Write a query to generate the total number of invoices, the invoice total for all of the invoices,…

A: Structured Query Language (SQL) has some built-in functions they are : “SUM()” - This function is…

Q: Which clause of a SQL Select statement is required if we want to display aggregate data by category…

A: Answer: 5) GROUP BY

Q: Write a query to display the patron ID, full name (first and last), and patron type for all patrons.…

A: In SQL, to sort the query output "order by" clause is used. In SQL, by default sorting on a…

Q: Q2/ The difference between the results of executing the following two SQL commands: delete from…

A: Answer to the given question: delete from Employee: will delete all the tuples from the Employee…

Q: SELECT name FROM instructor WHERE salary = 90000; This query can be replaced by which of the…

A: In the given sql query, the "instructor" table is used. But in option b and option c, employee table…

Q: Your manager requires you to create an SQL query that will display the combined customer name, the…

A: SQL query to select customer name ,townhouse number ,material and purchase amount ,in which purchase…

Q: SQL SELECT name, yrgoal, contamt 2 FROM donor, donation 3 WHERE donor.idno = donation.idno AND…

A: Given are two tables, Donor table and Donation table. Donor table has attributes idno, name, stadr,…

Q: Write a query to display all vendors sorted by vendor name. Write a query to display the product…

A: Database management queries are

Q: The Binder Prime Company wants to recognize the employee who sold the most of its products during a…

A: Actually, given information: The Binder Prime Company wants to recognize the employee who sold the…

Q: SELECT emp_name FROM department WHERE dept_name LIKE ' [A]Computer Science'; In the above-given…

A: I have given answer in next step

Q: Q1) Write a query that count the employees in each department? Q2) Write a query that retrieve all…

Q: Based on table below, using oracle: used subqueries, display the name of supplier(s) that supplied…

A: MAX will fetch the maximum value in column

Q: In the SQL Oracle Application, Within the Employees table, each manager_id is the manager of one or…

A: Answer: SELECT manager_id, job_id, SUM(salary) "total salary", GROUPING(manager_id),…

Q: When used in a parameter query, which of the following WHERE clauses will select the records for…

A: Parameter Query When a Query is used multiple times with different values each time, parameter query…

Q: Write a query to display the first name, last name, street, city, state, and zip code of any…

A: Actually, SQL is a language to operate databases in searching and filtering the data according to…

Q: Write a query to fetch details of employees whose EmpLname ends with an alphabet ‘A’ and contains…

A: Given, 'EmpLname' is the column name of the table. The last name of the employee ends with the…

Q: Write a query to display the patron ID, last name, number of times that patron has ever checked out…

Q: 19. Write a query to generate the total number of invoices, the invoice total for all of the…

A: Built-in functions: Structured Query Language (SQL) has some built-in functions and they are:…

Q: In the below given query, which expression is evaluated first? SELECT id_number, (quantity – 100 /…

A: Question. In the below given query, which expression is evaluated first? SELECT id_number, (quantity…

Q: Write a query to display supplier name, category and quantity with prices between 10 and 30(without…

A: Due to Bartleby guidelines we are only able to answer three questions in a solution. Kindly repost…

Q: The following query reports the employee with the highest salary amount per postal code for…

A: SQL

Q: 3. Run a query that gives the average grade on the final exam for male students and for female…

A: Since we need two groups of data i.e male and female, we must use group by clause and perform…

Q: I have the following problem for which I wrote teh code, but I am missing to round the last column…

A: Solution: Following is the query that retrieves assignment number, employee number, project number,…

Q: True or False? The select query is not required when retrieving information.

A: We are given a statement in sql in query and we will see if it is true or not.

Q: 8- Write a query to generate the total number of invoices, the invoice total for all of the…

A: Objective: A query should be written to display the total number of invoices, the invoice total for…

Q: ! The difference between the results of executing the following two SQL commands: Alter table…

A: Answer: The ALTER TABLE statement is used to add, delete, or modify columns in an existing table…

Q: Management wants to display the resort details in which total guest stayed was 10 or less than.…

A: Given Information: In this question we have to create a SQL query to show the resort Id, the total…

Q: Examine the table structure as given. SOL» DESC employees Name Null? Type - EMPLOYEE_ID NOT NULL…

A: The answer is

Q: Cities having Summer Temperature More than Jaipur Write a query to display all the town names which…

A: Required: Write a query to display all the town names which has summer temperature more than…

Q: When you don’t know the specific value to include in the criteria, you use a ____. a.…

A: Explanation: Parameter query is a type of query, one can update the information easily. It prompts…

Q: Suppose a query shrkByStoreByWeek that determined the dollar amounts and counts of shrinkage by…

A: Answer to the given question: To create a new query show shrinkage by the store we need to open the…

Question

i need help with these examplesin database

Assuming that this query displays the Employees whose first name starts with letter A, which
condition should be added to make it true ?
Select Lname || fname as name , salary from employee where
a. Instr(fname,'A') = 0 ;
O b. Instr(fname,'A') = 1 ;
c. Initcap(fname) Like 'a%' ;
O d. Fname Like '_A%' ;

Which command is used to add new column (Budget) to project table where the budget must not
exceed 200000$?
a. Alter table project add column (budget number not null);
O b. Alter table project add (budget number not null >200000);
C. Alter table project add (budget number check(budget < 200000));
O d. Alter project add column (budget <200000);

Organized collection of structured information, or data, typically stored in a computer system.

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 4 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

Write a query to display the movie number, movie genre, average cost of movies in that genre, cost of the individual movie, and the percentage difference between the average movie cost and the individual movie cost. The results are shown in Figure P7.98. The percentage difference is the cost of the individual movie minus the average cost of movies in that genre, divided by the average cost of movies in that genre multiplied by 100. For example, if the average cost of movies in the family genre is 25 and a given family movie costs 26, then the calculation would be ((26 25) / 25 100), or 4.00 percent. In this case, the individual movie costs 4 percent more than the average family movie.
Table: Employee | Column Name| Type| | id | int | | int | | salary +- -------+ id is the primary key column for this table. Each row of this table contains information about the salary of an employee. Write an SQL query to report the second highest salary from the Employee table. If there is no second highest salary, the query should report null.
Because the SELECT clause contains the Customer* column, which clause must be included for the query to execute successfully? 1 SELECT customer#, COUNT(*)2 FROM customers JOIN orders USING(customer#)3 WHERE orderdate > '02-APR-09'4 GROUP BY customer#5 HAVING COUNT(*) > 2;
7. SELECT name FROM instructor WHERE salary = 90000; This query can be replaced by which of the following ? a) SELECT name FROM instructor WHERE salary BETWEEN 90000 AND 100000; b) SELECT name FROM employee WHERE salary =100000; c) SELECT name FROM employee WHERE salary BETWEEN 90000 AND 100000; d) SELECT name FROM instructor WHERE salary BETWEEN 100000 AND 90000;
Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns. In addition, you must calculate the order total from the columns in the OrderItems table. Write a second SELECT statement that uses the first SELECT statement in its FROM clause. The main query should return two columns: the customer�s email address and the largest order for that customer. To do this, you can group the result set by the EmailAddress column.
Task 18: List the item ID, description, unit price, and category for each item that has a unit price greater than the unit price of every item in category CAT. Use the ALLoperator in your query. Task 20: Repeat Task 18 using the ANY operator. *Both are needed answered but ideally task 20 needs to be done, task 18 is here for task 20
Draw the ERD that is implemented by the following SQL code: CREATE TABLE PROJ_USER USER_ID NUMBER NOT NULL, USER_NAME VARCHAR2(50) NOT NULL, USER_EMAIL VARCHAR2(50) NOT NULL, CONSTRAINT USER_PK PRIMARY KEY (USER_ID) ); CREATE TABLE PROJ_CERTIFIEDUSER USER_ID NUMBER NOT NULL, CUSER_REALNAME VARCHAR2(50) NOT NULL, CUSER_CERTIFICATION VARCHAR2(50) NOT NULL, CONSTRAINT CERTIFIEDUSER_PK PRIMARY KEY (USER_ID), CONSTRAINT CERTIFIEDUSER_FK FOREIGN KEY (USER_ID) REFERENCES PROJ_USER (USER_ID) );
A subquery must be placed in the outer query's HAVING clause if: 1.The subquery returns more than one value to the outer query. 2The value returned by the inner query is to be compared to grouped data in the outer query. 3.The inner query needs to reference the value returned to the outer query. 4.None of the above. Subqueries can't be used in the outer query's HAVING clause.
Q5: From the Customer table given below write SQL queries for the following question?  Write a query to display the record of the last name and city with unique state? Write a query to display the record of the distinct cities of the customers? Write a query to display the records of customers' address whose names contain letter “a”?
WEEK SQL ASSIGNMENT Complete the following exercise: Alter your student table adding a new column called enroll_date using the datetime data type. Populate the new column (enroll_date) with the current date and time. Using your student table return the student first and last names concatenated with a space and then the enroll_date minus one month. Here is an example of the output: Name Date Jane Smith 2019-05-03 13:14:12 Tom Jones 2020-08-07 05:23:56 Using your student table return the month name for the enroll_date column. For example, if the enroll_date was 11-6-2019 then the month name would be June.
question Write the SQL code to validate the ASSIGN_CHARGE values in the ASSIGNMENT table. Your query should retrieve the assignment number, employee number, project number, the stored assignment charge (ASSIGN_CHARGE), and the calculated assignment charge (CALC_ASSIGN_CHARGE, calculated by multiplying ASSIGN_CHG_HR by ASSIGN_HOURS and rounded to two decimal places). Sort the results by the assignment number. The results of running that query are shown in Figure P7.5. After running the command I was only getting long numbers
Draw the ERD rI : ithat is implemented by the following SQL code: CREATE TABLE PROJ_USER USER_ID NUMBER NOT NULL, USER_NAME VARCHAR2(50) NOT NULL, USER_EMAIL VARCHAR2(50) NOT NULL, CONSTRAINT USER_PK PRIMARY KEY (USER_ID) ); CREATE TABLE PROJ_CERTIFIEDUSER USER_ID NUMBER NOT NULL, CUSER_REALNAME VARCHAR2(50) NOT NULL, CUSER_CERTIFICATION VARCHAR2(50) NOT NULL, CONSTRAINT CERTIFIEDUSER_PK PRIMARY KEY (USER_ID), CONSTRAINT CERTIFIEDUSER_FK FOREIGN KEY (USER_ID) REFERENCES PROJ_USER (USER_ID) );

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Programming with Microsoft Visual Basic 2017

Computer Science

ISBN:

9781337102124

Author:

Diane Zak

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS