The following database will be used in this question:SALESREPSalesRepNo654734345434RepNameJonesSmithChenJohnsonHireDate01/02/200502/03/200701/25/200411/23/2004CUSTOMERCustNo9870859078404870CustNameWinstonGonzalesHarrisMilesBalance500350SalesRepNo345434654345800100 c) Write the standard MYSQL query to retrieve the Name and CustNumber of customers with abalance greater than 50d) Write the standard MYSQL query to retrieve the Name and CustNumber of customers whosename begins with 'S'.

In the question it is asked for retrieving the Name, But in the CUSTOMER table there is column name…

c) Write the standard MYSQL query to retrieve the Name and CustNumber of customers with a balance greater than 50 d) Write the standard MySQL query to retrieve the Name and CustNumber of customers whose name begins with 'S'.

c) Write the standard MYSQL query to retrieve the Name and CustNumber of customers with a balance greater than 50 d) Write the standard MySQL query to retrieve the Name and CustNumber of customers whose name begins with 'S'.

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: Write a query to list the first name and last name of all authors. Concatenate the first and last…

A: The SQL query is: SELECT CONCAT(CONCAT(firstname,' '),lastname) AS FullName FROM author;…

Q: What is the result of the query below: SELECT V_CODE, COUNT (P_CODE) FROM PRODUCT HAVING V_CODE…

A: Answer: Data is filtered using the having clause in accordance with the specified requirements.…

Q: Use the Committee table and create a query that displays the following output: Name FullAddress…

A: The query is given as per mysql in the next step:

Q: Write a query to display the employee number, first name, last name, and largest salary amount for…

A: Actually, database is a used to stores the data.

Q: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: Question 6 (Must include subquery): Write, a query that returns every customer that has a loan at…

A: The query is given below with output screenshot Demo data has been used in tables

Q: Question 4 Write a mysql query to get the answer to the following question using the given tables…

A: Answer in the next step

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Schema: Employees (EmpID int, Name varchar(50), Age int, Salary float, DepartmentID int)…

A: HI THERE,I AM ADDING ANSWER BELOWPLEASE GO THROUGH ITTHANK YOU

Q: Design a query of Stores with the following: Store Name, Store Size, Sum of order amounts, Percent…

A: JOIN Based on a common column between two or more tables, a JOIN clause is used to merge rows from…

Q: Salesforce Assignment: Write a SOQL Query to find out all contact where the account id is not equal…

A: Introduction: Similar to the SELECT command in Structured Query Language (SQL), SOQL allows you to…

Q: 3) Write an SQL query to display the accountno, name, Recurrent_acno, transaction_date whose Fixed…

A: Required:

Q: reate a query that SELECT all of the EMPLOYEES from the EMPLOYEE TABLE that are Mangers. Include…

A: SQL provides a standardized way to communicate with databases regardless of the specific RDBMS being…

Q: Using Pubs: USE MICROSOFT SQL SERVER Create a query listing all the books that Barnum’s purchased.…

A: I attached your answer below.

Q: hoose 1 string function and 1 numeric function and write a query that uses the two functions you…

A: The given problem is related to MYSQL querie where the logical model of the tables is given and the…

Q: FROM SALESPERSON WHERE SPNUM= (SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772): What is this subquery…

A: Given subquery SELECT SPNUM FROM CUSTOMER WHERE CUSTNUM=772

Q: Write the following as the MySQL query: List the employee ID, first name, last name, hire date,…

A: In database administration, it is frequently essential to extract particular data from a dataset…

Q: write a MySQL procedure to retrieve and output the item number, description, storehouse number, and…

A: Always prefer to provide database of table.

Q: Select clause and from clause: Display the columns specified above in the problem statement from…

A: Write a query to display the author ID, first name, last name, and year of birth for all authors…

Q: I want to see how to do this using RELATIONAL algebra. I posted this and someone showed me how to…

A: The query will be solved using difference operator - and natural join operator ⋈ R1=…

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: ) Write a query that uses NATURAL JOIN TO connect the EMPLOYEE and EMPPROJACT table. Include the…

A: Here, we have to write SQL queries for the given statements.

Q: 3. Write a query that retrieves the following results (note the column names and order of results):

A: The required result needs to fetch below columns : Pub_id -> from publisher table Publisher's…

Q: 1. Write a query to retrieve student id, name, SERA of students from a student into table. 2. List…

A: Note: Here you asked 6 different questions so I'm going to answer the first three questions.…

Q: a) Create the two tables above and insert the data in the rows accordingly. b) Write the standard…

A: Hi Student. Warm welcome from my side. Hope you are doing great. Here is your answer.

Q: Write the following as MySQL query: Find the department name whose location (Country_ID) is DE. Use…

A: SQL, which stands for Structured Query Language, is a domain-specific programming language used for…

Q: 23.Write a SQL query to add constraint PRIMARY KEY to the column Pro_ ID with a suitable constraint…

A: A Primary key is a set of attributes that can identify each tuple uniquely of the given relation. It…

Q: 7) Write a query to display Unique order dates from the shipper named “Speedy Express”.

A: According to Bartleby Guidelines we need to answer only one question so I have answered first…

Q: using oracle19c a)Write One query using a single table b) Write four queries using more than one…

A: Given that using oracle19c a)Write One query using a single tableb) Write four queries using more…

Q: 1. Write a SQL query to list first name, last name and rank of only professors whose rank is…

A: According to Bartleby Guidelines we need to answer only one question so I have answered first…

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

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Please write the MySQL query for the following task: Find the first_name, last_name, employee_id,…

A: we can use the following MySQL query:

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

A: Number list = [12,9,2,5,-7,3]. Bubble sort: In bubble sort works by repeatedly swapping the adjacent…

Q: Write an SQL query to find all customers whose name (either last name or first name) contains…

A: The following SQL queries can be used to achieve various tasks related to data searching and…

Q: . Using the Henry Books database, list the book code and title of every book that has the type SFI…

A: In this question we have to write a query for using a Henry book database for the given queries…

Q: Write an SQL query using the ALTER TABLE and ADD operator to add anattribute named ORDERDATE with…

A: ALTER TABLE command: The ALTER TABLE command is used to add new columns, modify columns in an…

Q: Write a query to display the record of the person living in Rawalpindi and Karachi? Write a query to…

A: SQL syntax to create a table: Create table tableName(columnName1 dataType, columnName2 dataType,…

Q: 1. a) Create a table bank_master Column Name Datatype Varchar2(4) Varchar2(30) Varchar2(30) Number…

A: Given that We have to create table Bank_Master and insert data into it Part 2 We have to create…

Q: Write a query using mysql to find the title and amount of the grants for which Professor “Yann…

A: NOTE Below is the answer for the given question. Hope you understand it well. If you have any…

Q: 5) Write an SQL Query to display the accountno, name, Recurrent_acno, amount whose fixed deposit…

A: Required:

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

A: Algorithm:Join Tables: Join the PATRON and CHECKOUT tables on the Pat_ID to associate patrons with…

Q: Write an SQL query using the AND operator that show all orders shoppedon April 1, 2009 shipped to…

A: SQL query: SELECT * FROM Orders WHERE order_date = ‘April 1, 2009’ AND state = ‘Florida’;

Q: 6) Write an SQL query to find the minimum fixed deposit of each recurrent_acno whose…

A: Statement to create table: CREATE TABLE bank_details ( Recuurent_acno VARCHAR(24), ac_no INT,…

Q: Table 84: 5 records g dna 1 АCGGCTTAТCGAACTGCGTC 2 TCAGGAATAGCCAAAGACСС 3 TТАTGGTAТСТAGGCTCTG 4…

A: write a query to generate 5 random DNA sequences that are each about 20 bases.

Q: You have been told that you need to store the zip code for employees. Add a column to the EMPLOYEE…

A: Hello student Greetings In this scenario, we are required to add a new column to the EMPLOYEE…

Q: Write an SQL query using the NOT operator that will show all employeeinformation from the Employee…

A: SQL query: SELECT * FROM Employee WHERE NOT Employee_Number = 7344;

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

c) Write the standard MYSQL query to retrieve the Name and CustNumber of customers with a
balance greater than 50
d) Write the standard MYSQL query to retrieve the Name and CustNumber of customers whose
name begins with 'S'.

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

( c )

c ) Answer

( d )

d ) Answer

Trending now

This is a popular solution!

Step by step

Solved in 4 steps

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 an SQL query using the UPDDATE and SET operator that willoverwrite all values containing 16 with 32 in the SupplierID attribute inthe Products table.
Write4 query to find the balance characteristics for all customers, including the total of the outstanding balances. The results of this query are shown in Figure P7.39.0.
d. write a query to retrieve the name of graduate student and student advisor name of all graduate student.
Write a query in SQL code for: "List the book categories and the average book price of each category." Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY
1. Write an SQL query to list the name of all Departments that have 2 more more words in the Department name and whose employees have the designation of a ‘staff’ and are from Houston. (write subqueries) 2. Write an SQL query to display the Project Name of all projects where employees have worked for 5 hours or less or 25 hours or more and the Project Names start with a “T” or a “C”. (write subqueries)
Write an SQL query using a Wildcard operator that will show any ISBNstarting with 995 in the Books table. This query must also show the ISBNand the book title only.
HW2: Basic SQL 1. Write a query that will show all probation officers 2. Write a query that will show the first and last names of probation officers 3. Now write a query that shows first and last name of probation officers. Include the field prob_id but rename prob_id to probation officer ID. 4. Write a query that will show crime id, and the total charges for each crime ID. Include an alias for the total charges column called Total Charges. 5. Write a query that will concat the last and first names of criminals into one column. Add a space and comma between the last and first name of criminals. Give the column the alias Criminal Name. 6. List the last name and first name of all authors in only 1 column. Add a comma to separate the two names. 7. Run a query that will return the order#, item#, isbn, quantity, paideach. Include in the query a arithmetic operation that will total quantity and paideach. Alias the virtual column so it is labeled Item Total
Problem 53 LargeCo is planning a new promotion in Alabama (AL) and wants to know about the largest purchases made by customers in that state. Write a query to display the customer code, customer first name, last name, full address, invoice date, and invoice total of the largest purchase made by each customer in Alabama. Be certain to include any customers in Alabama who have never made a purchase; their invoice dates should be NULL and the invoice totals should display as 0. Sort the results by customer last name and then first name (Partial result are shown in Figure P7.53).
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
Using Oracle19c a. Write One query using a single tableb. Write four queries using more than one table. i. A query using arithmetic operators while defining an attribute ii. Explicit set and renaming attribute iii. Use nested queries including:  Using IN operator  Using relational operator with ANY/SOME or ALL  Using Except operator
Insert into table customerPayment, columns customerOrderld and total result set returned from query a. Select columns id and total from table customerOrder where column orderStateld is equal to subquery i. (select column id from table orderState where column state is equal to "Payment received") Write Test Case 1 as a SQL join query to do the following a. Select using concatenation of columns firstName and lastName from table www customer as Customer b. Select customerOrderId from table customerPayment as "Customer Order" c. Select description from table product as Product d. Select total from table customerOrder as “Product Total" e. Join tables customerPavment, customerOrder, customer, product f. Order by column lastName from table customer Alter table purchaseOrder add column total as data type decimal size 7,2, not null, default value of 0.0
b. Write a query to get the average salary and the total number of employees who work in the History department (in that order). c. Write a query to get the number of employees working in the History department with a job title of Head of Department.