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: 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: Write SQL retrieval commands for each of the following queries: Display the course lD and course…

A: Note: As per policy we are entitled to answer the 3 subparts of the question. 1) a. SELECT…

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: 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: Create a query based on the EMP table that satisfies the criteria below Use the TO_CHAR function to…

A: Solution: When you install Oracle 11g Enterprise Edition there are couple databases you can chose…

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: Guest details and Total Charges paid Develop a simple SQL query Display guest details who paid total…

A: According to the given table schema and problem statement out task is to develop a SQL query a to…

Q: a) Write an SQL query to find the manufacturer and model for all aircraft models with capacity at…

A: a) SELECT Manufacturer , Model FROM Aircraft_Models WHERE Capacity>=300 ; b)…

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: Write the relational algebra formula to apply an INTERSECT relational operator to the tables

A: Relational algebra formula for Intersect Relational Operator: An Intersect relational operator…

Q: Student(StudentID, age) School(SchoolID, city) Write an SQL statement for the following query: For…

A: The above question is solved in step 2:-

Q: Write all the sql code (including create, insert and select)

A: #use the below query to create users tablecreate table users(account int primary key,name…

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 a MySQL procedure to retrieve and output the item number, description, storehouse number, and…

A: Always prefer to provide database of table.

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 an sql query to show country code, country name of those employees whose country name…

A: Please refer below for your reference: Queries: 1.SELECT country code, country name FROM employees…

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: 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: Create a PL/SQL query to display the combined customer name, coin purchased, coin price andthe…

A: THE GIVEN SQL QUERRY FOR THE QUESTION

Q: Create a query that uses any THREE of the tables (SCHOOL, DEPARTMENT, PROFESSOR, TECHNOLOGY &…

A: Creating all the three tables required for the question-For Department-create table…

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: SQL SUM Problem -SELECT * FROM [Sale Order] INNER JOIN Product ON [Sale Order] productID =…

A: Structured Query Language (SQL) is a programming language used to create, manipulate and query data…

Q: How can the CAST function be combined with other functions to enhance data type compatibility in SQL…

A: The CAST function can be combined with other functions to enhance data type compatibility in SQL…

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

Based on the given table. Customer ID Name Balance Payment 193 Chen 2100 300 584 Ravindran 5000 250 231 Bolt 300 20 608 Gomez 950 125 What values are returned while the given query is executed? SELECT 2* (Balance - Payment) FROM Customer; 3900, 9750, 590, 1775 3600 3600, 9500, 560, 1650
Create a function to increment the salary of employees of an organization by 15%, and for employees with department ID 100 give another 10% hike on the updated salary. Also, write the query to update the salary of all records of the salary column in the employee table using the created function. In PL/SQL
Write all the sql code (including create, insert and select)
Please no written by hand and no emage D As Question 3 A correlated nested query O uses tables from both the inner and the outer queries is executed once for every tuple in the outer query table O both 1 and 2 O neither 1 and 2
Write an SQL query to print the first three characters of FIRST_NAME from Worker table. Write an SQL query to find the position of the alphabet (‘j’) in the first name column ‘John’ from Worker table
Create a PL/SQL query to display the combined customer name, coin purchased, coin price and the delivery notes. In your query only display the coins purchased with a price less than or equal to R 8 000. Sample Output: CUSTOMER: Mat, Smith COIN: 1oz Gold Kruger Rand PRICE: R 5 999 NOTES: Double packaging requested CUSTOMER: Lucy, Williams COIN: 1oz Gold Kruger Rand PRICE: R5 999 NOTES: No notes CUSTOMER: Sam, Clark COIN: loz Silver Palaeontology PRICE: R7 999 NOTES: Delivery to work address
Write SQL retrieval commands for each of the following queries: Display the course lD and course name for all courses with an ISM prefix. Display all courses for which Professor Berndt has been qualified. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212. Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113? Write an SQL query to answer the following question: ls any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930? Write SQL queries to answer the following questions: How many students were enrolled in section 2714 during semester I-2008? How many students were enrolled in lSM 3113 during semester l-2008? Write an SQL query to answer the following question: Which students were not enrolled in any courses during semester l-2008?
a) Write a SAS SQL statement to retrieve all columns fromPG1.STORM_FINAL.(b) Modify the query to retrieve only the Season, Name, StartDate, andMaxWindMPH columns. Format StartDate with MMDDYY10.(c) Modify Name in the clause to convert the values to proper case.(d) Add a clause to include storms during or after the 2000 season withMaxWindMPH greater than 156.(e) Add a clause to arrange rows by descending MaxWindMPH, and then byName.(f) Add a proper statements to describe the report.
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)
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).
4. Write an SQL query to find the name of the departments such that the average salary of theinstructors in the department is larger than 80,000.
Create a PL/SQL query to display the customer’s name, employee name, donation, dispatch date and the delivery date. In your query, also display the number of days between the dispatch date and the delivery date in days for customer 11013.