Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

sql

Class work


1. Create Customers

1. Create the following table

2. Please ensure that any previous table is dropped first to prevent any conflicts

3. Submit a screenshot of the table created as evidence of the customers table.

DROP TABLE CUSTOMERS;

CREATE TABLE CUSTOMERS

  CST_NUM             CHAR(4), 

  CST_NME_LST VARCHAR2(20), 

  CST_NME_FST VARCHAR2(20), 

  CST_EML      VARCHAR2(25), 

  CST_ADR      VARCHAR2(25), 

  CST_CTY   VARCHAR2(20), 

  CST_ST    CHAR(2), 

  CST_ZIP   CHAR(5), 

  CST_REF   NUMBER(4), 

  CST_REG   CHAR(2)  

);

2. Add Data to the Customers Table

1. Please add the following records to the customer table

2. Afterwards, submit a screenshot as evidence that the records have been populated to the table.

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1001′,’MORALES’,’BONITA’,’P.O.BOX 651′,’EASTPOINT’,’FL’,’32328′, NULL, ‘SE’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1002’, ‘THOMPSON’, ‘RYAN’, ‘P.O. BOX 9835’, ‘SANTA MONICA’, ‘CA’, ‘90404’, NULL, ‘W’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1003’, ‘SMITH’, ‘LEILA’, ‘P.O. BOX 66’, ‘TALLAHASSEE’, ‘FL’, ‘32306’, NULL, ‘SE’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1004’, ‘PIERSON’, ‘THOMAS’, ‘69821 SOUTH AVENUE’, ‘BOISE’, ‘ID’, ‘83707’, NULL, ‘NW’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1005’, ‘GIRARD’, ‘CINDY’, ‘P.O. BOX 851’, ‘SEATTLE’, ‘WA’, ‘98115’, NULL, ‘NW’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1006’, ‘CRUZ’, ‘MESHIA’, ’82 DIRT ROAD’, ‘ALBANY’, ‘NY’, ‘12211’, NULL, ‘NE’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1007’, ‘GIANA’, ‘TAMMY’, ‘9153 MAIN STREET’, ‘AUSTIN’, ‘TX’, ‘78710’, ‘1003’, ‘SW’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1008’, ‘JONES’, ‘KENNETH’, ‘P.O. BOX 137’, ‘CHEYENNE’, ‘WY’, ‘82003’, NULL, ‘N’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1009’, ‘PEREZ’, ‘JORGE’, ‘P.O. BOX 8564’, ‘BURBANK’, ‘CA’, ‘91510’, ‘1003’, ‘W’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1010’, ‘LUCAS’, ‘JAKE’, ‘114 EAST SAVANNAH’, ‘ATLANTA’, ‘GA’, ‘30314’, NULL, ‘SE’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1011’, ‘MCGOVERN’, ‘REESE’, ‘P.O. BOX 18’, ‘CHICAGO’, ‘IL’, ‘60606’, NULL, ‘N’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1012’, ‘MCKENZIE’, ‘WILLIAM’, ‘P.O. BOX 971’, ‘BOSTON’, ‘MA’, ‘02110’, NULL, ‘NE’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1013’, ‘NGUYEN’, ‘NICHOLAS’, ‘357 WHITE EAGLE AVE.’, ‘CLERMONT’, ‘FL’, ‘34711’, ‘1006’, ‘SE’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1014’, ‘LEE’, ‘JASMINE’, ‘P.O. BOX 2947’, ‘CODY’, ‘WY’, ‘82414’, NULL, ‘N’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1015’, ‘SCHELL’, ‘STEVE’, ‘P.O. BOX 677’, ‘MIAMI’, ‘FL’, ‘33111’, NULL, ‘SE’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1016’, ‘DAUM’, ‘MICHELL’, ‘9851231 LONG ROAD’, ‘BURBANK’, ‘CA’, ‘91508’, ‘1010’, ‘W’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1017’, ‘NELSON’, ‘BECCA’, ‘P.O. BOX 563’, ‘KALMAZOO’, ‘MI’, ‘49006’, NULL, ‘N’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1018’, ‘MONTIASA’, ‘GREG’, ‘1008 GRAND AVENUE’, ‘MACON’, ‘GA’, ‘31206’, NULL, ‘SE’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1019’, ‘SMITH’, ‘JENNIFER’, ‘P.O. BOX 1151’, ‘MORRISTOWN’, ‘NJ’, ‘07962’, ‘1003’, ‘NE’);

INSERT INTO CUSTOMERS (CST_NUM, CST_NME_LST, CST_NME_FST, CST_ADR, CST_CTY, CST_ST, CST_ZIP, CST_REF, CST_REG) 

   VALUES (‘1020’, ‘FALAH’, ‘KENNETH’, ‘P.O. BOX 335’, ‘TRENTON’, ‘NJ’, ‘08607’, NULL, ‘NE’);

3. Display the following Queries

1. 1.All records from the customer table.

2. 2.List of all customers in the state of Florida

3. 3.All customers that reside in zip code 82003

4. 4.All customers with the last name Smith

5. 5. List all customers who live in Miami

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

co task 6

Topic-bitcoin Task 6 Objective: To apply systems thinking principles to analyze a blockchain network and understand its key components, interactions, and dynamics. Assignment Tasks: Select a Blockchain Network: Choose a specific blockchain network or cryptocurrency project to analyze. You can select well-known networks like Bitcoin, Ethereum, or any other blockchain

CO Task 5

In this homework, we explore Naïve Bayes, K-Nearest Neighbors, and Support Vector Machine models. 1) (50 points) Use “credit_Dataset.arff” dataset and apply the Naïve Bayes, K-Nearest Neighbors, and Support Vector Machine technique using the WEKA tool in 2 different settings, including: a. 10 fold-cross validation. b. 80% training. Write a

PhD thesis

I need a comprehensive PhD thesis developed on the topic of “Emotion-Aware Artificial Intelligence and Sustainable Consumer Behavior: A Neuro-AI Marketing Framework for Continuous Green Consumption.”

Co project

· Comprehensive Literature Review: Require a more comprehensive survey of existing approaches. · Comparative Study: Expect more detailed benchmarking of at least 8 to 10 machine learning models. · Additional Experiments: · Conduct feature selection or dimensionality reduction as an extra step. · Explore ensemble methods or advanced techniques beyond

AI

Did AI take place the Software Engineers, HR consultants and Data Entry Jobs?

Data visualization 4 part 2

Follow the attached instructions to complete this work. Unit 4 Assignment Directions: Time Series In this assignment, you will perform a time series analysis in Tableau. · Choose a dataset to analyze based on the requirements provided.   · Once you’ve selected your time series, build a forecast to predict future

Computer Science CG Assignment 8 presentation

Follow the attach instruction to complete this work. Note: Make sure it aligns with Rubric Unit 8 Assignment 2 Directions: Final Presentation Purpose With this presentation, you will gain valuable experience demonstrating your expertise in cybersecurity governance by presenting as a CISO to a hypothetical professional audience.  Directions Begin by incorporating

Computer Science CG assignment 8

Follow the attached assignment to complete the work. Note: Follow Rubric Unit 8 Assignment 1 Directions: Presentation Rehearsal Purpose The rehearsal is your first run-through of your talk. Use the opportunity to de-bug any technical issues with lighting, positioning, and recording. You will not be graded on technical or artistic

Computer Science CG assignment 7 Outline

 Follow the attached document to complete this work Unit 7 Assignment 1 Directions: Professional Presentation Outline Purpose This assignment allows you time to review your research from previous units and organize your thoughts in an outline format. Plan on changing your paper and presentation based on feedback on this outline.  Directions

Computer Science CG assignment 6 ,

Follow the attached direction to complete this work. Note: Make sure it Aligns with Rubric Unit 6 Assignment 2 Directions: Timothy Brown vs. the SEC Purpose The Securities and Exchanges Commission (SEC) is a key US federal agency that regulates financial reporting. In this paper, you will explore how the

Microsoft 365Tenant to Tenant Migration Solution

A smooth tenant-to-tenant migration requires more than just moving mailboxes—it demands precision, security, and planning. With the MailsDaddy Cross-Tenant Migration Service, IT teams can execute a flawless cross-tenant mailbox migration that covers emails, attachments, calendars, contacts, and OneDrive data. It’s built for businesses of every size, ensuring the entire Office

CO Data 3

DECISION TREES for Risk Assessment One of the great advantages of decision trees is their  interpretability. The rules learnt for classification are easy for a person to follow, unlike the opaque “black box” of many other methods, such as neural networks. We demonstrate the utility of this using a  German

Computer Science Homework 1

MMIS 671 Homework 1. Constrained Optimization Problems A company produces 3 types of cables: A, B, and C. In-house production costs per foot of cables A, B, and C are $6, $8, and $10, respectively. The production process requires 5 resources: Drawing, Annealing, Stranding, Extrusion, and Assembly. For each resource,

MIMT

  Task 2.4 — Executing the Payload After decrypting and executing the transferred file, it generates a unique hash tied to your GTID. What’s the hash?

data Discussion 3

Follow the attached instructions to complete this. use the   CRM Sale Dashboard. Unit 3 Discussion: Deconstruction of an Advanced Dashboard: Trends and Improvements   Discussion Prompts · Does the dashboard designer use any of the trends that are described in Milligan’s Chapter 9? · If they did use those