Write the SQL1. Select a customerid and last name, for a customer, whose order price is above 50 dollars; CUSTOMERPrimaryKey CHAR(4)Text CHAR(35)Decimal DECIMAL(4,2)Text CHAR(2)CUSTIDLASTNAMEORDERPRICEPRODUCTID6358RogersMaldonado65.8513968552.23132235Chen55.98549821Basheer70.99198756Yafet44.8421PURCHASEPrimaryKey CHAR(4)Text CHAR(35)LOCATIONDATEText CHAR(5)PRODUCTIDPURDATEPICKUPCODE34BRONX21-JAN-2020FD3554BROOKLYN12-JUL-2020RE56QUEENSSTATEN ISLAND 10-DEC-20201322-OCT-2019UY3219NV2321LONG ISLAND78-MAR-2019WE35STOREPrimaryKey CHAR(4)Text CHAR(10)Text CHAR(5)STORETIMEPICKUPCODENV23STOREDAYTUESDAY10amXF56UY32TUESDAY8amWEDNESDAY8amFD35WEDNESDAY1lamLE56FRIDAY1pm

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

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

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

Similar questions

answer with proper explanation and step by step solution. Question write a PL/ SQL program to display the number of products whose price is 100 dh more or less than the price defined the for substitution variable use the define command to specify the price pass this value to the PL/SQL black using a substitution variable
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.
Write two SQL Queries that will show the ORDER# from both the Orderand OrderItems table using the UNION set operator
Write a function named product that takes two int parameters and returns the product of those two integers. Here is an example: int n = product(7, 5); // n is 35 We are providing a test framework that, if you wish, you may use with a compiler to test your function. What you will submit as your answer to this problem is only the product function. Do not submit things like the #include lines or a main routine. If we take the code you write in the space below and insert it into the program, the resulting program must build without compilation errors (mere warnings are allowed). You do not need to write comments in the code; we will not look at any comments. Here is the test framework that you may copy and paste into a C++ source file. For your own testing purposes, you might add additional tests in the main routine, although you won't be turning them in, of course. #include <iostream> #include <cassert> using namespace std; // SUBMIT AS YOUR ANSWER ONLY THE CODE BETWEEN THIS…
SQL Database Write PL/SQL or T-SQL procedures to retrieve and output the reservation ID, trip ID, number of persons, and trip price for every reservation whose customer number is stored in I_CUSTOMER_NUM
Write the SQL syntax to create a table in the database called Employee with the employee first and last name, employee hire date, employee number, employee initial, and employee years.
7. List the shipping city and state for the order that had the longest shipping delay. SQL commands
how do you use PL/SQL or T-SQL procedures in SQL?