Question: Write the following queries in SQL uisng the Yelp_db schema The Yelp_db schema can be found at the following link: https://www.yelp.com/dataset/documentation/main 4.1 Find business names

Write the following queries in SQL uisng the Yelp_db schema

The Yelp_db schema can be found at the following link:

https://www.yelp.com/dataset/documentation/main

4.1 Find business names whose zip code begins with '1' and ends with '1'. You can assume that zip code consists of five digits. The result should be following.

Write the following queries in SQL uisng the Yelp_db schema The Yelp_db

4.2 Find the total number of checkin per business, which is located in 'NY' state. Sort by the total checin number. Note that the total number of checkin must be ZERO if there is no checkin (Hint: check the mysql function 'IFNULL'). The result should be the following:

schema can be found at the following link: https://www.yelp.com/dataset/documentation/main 4.1 Find business

4.3 Find the total number of restaurants per (city and state). Sort the numbers. It is not necessary to display all results. The results should be the following:

names whose zip code begins with '1' and ends with '1'. You

postal_code name Ulta Beautv Nail Secrets Nine Stories 15241 15101 15201 Industrv Public House 15201 15201 15201 15221 15101 15201 Artisan Pizza Comoanv 15241 15201 NTB-National Tire &. 15101 15201 15201 Canterburv Place Healthv Ride Pah New Luckv Alpine Pools 31st Street Pub Paint Monkev Sent business 78

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...

PART 2 (35 points - 5 points each question) Write the following queries in relational algebra, using the schema provided for the MOVIES database. ACTOR (actor_id, first_name, last_name, last_update)...

If could, I would like to send you the word and pdf files to make it easier for you to solve the problem. You are working with the following relational schema for a university's course management...

A Case Study: You have been given the responsibility of constructing a database grounded on the ERD diagram ( refer to page 4 ) provided by Provisional Employment. Some reports are also required by...

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

Assignment 2 Relational Algebra Points: 50 Instructions: For this assignment you must submit a document file (in pdf or doc format) with answers to the following questions. PART 1 (15 points):...

Database design and technology As a database developer, you have been asked to design a new database the operation of the new project within the Liverpool John Moores University (LJMU). LJMU is...

1. Is this an example of fraudulent financial reporting or misappropriation of assets? 2. What created an opportunity to commit the fraud? 3. What was the "trail" created by the fraud, that is, what...

The local Driver's License Office has asked you to write a program that grades the written portion of the driver's license exam.The exam has 20 multiple choice questions. Here are the correct...

The 6 . 3 percent, semlannual coupon bonds of PE Engineers mature in 1 3 years and have a price quote of 9 9 . 2 . These bonds have a current yeld of percent, a yeld to maturity of percent, and an...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Suppose government spending increases. Would the effect on aggregate demand be larger if the Federal Reserve took no action in response or if the Fed were committed to maintaining a fixed interest...

Suppose that people suddenly wanted to hold more money balances. a. What would be the effect of this change on the economy if the Federal Reserve followed a rule of increasing the money supply by 3...

Suppose the federal government cuts taxes and increases spending, raising the budget deficit to 12 percent of GDP. If nominal GDP is rising 5 percent per year, are such budget deficits sustainable...