CUSTOMER PrimaryKey CHAR(4) CUSTID Text CHAR(35) LASTNAME Decimal DECIMAL(4,2) ORDERPRICE Text CHAR(2) PRODUCTID 6358 Rogers Maldonado 65.85 13 13 54 9685 52.23 Chen Basheer 2235 55.98 9821 70.99 19 8756 Yafet 44.84 21 PURCHASE PrimaryKey CHAR(4) PRODUCTID Text CHAR(35) LOCATION DATE Text CHAR(5) PICKUPCODE PURDATE 34 BRONX 21-JAN-2020 FD35 54 BROOKLYN 12-JUL-2020 RE56 QUEENS STATEN ISLAND 10-DEC-2020 13 22-OCT-2019 UY32 19 NV23 21 LONG ISLAND 78-MAR-2019 WE35 STORE PrimaryKey CHAR(4) PICKUPCODE Text CHAR(10) STOREDAY Text CHAR(5) STORETIME NV23 TUESDAY 10am XF56 TUESDAY Sam UY32 WEDNESDAY Sam FD35 WEDNESDAY 11am LE56 FRIDAY 1pm
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.
Write the SQL
1. Select a customerid and last name, for a customer, whose order price is above 50 dollars;
Step by step
Solved in 2 steps with 1 images
