Create database salesinformation

Assignment Help PL-SQL Programming

Reference no: EM131826904

Assignment

1. CREATE DATABASE salesinformation;

CREATE TABLE sales_data (sale_date date, client_name varchar, product_name varchar, total_dsum int);
SELECT total_dsum FROM sales_data WHERE total_dsum > 0; SELECT * FROM sales_data ORDER BY sale_date ASC;
SELECT * FROM sales_data ORDER BY total_dsum DESC;

2. CREATE TABLE sales_data (sale_date date, client_name varchar, product_name varchar, total_dsum int);
SELECT * FROM sales_data ORDER BY sale_date ASC; SELECT * FROM sales_data ORDER BY total_dsum DESC;

3. CREATE TABLE sales_info (sale_year int, sale_month varchar, client_name varchar, product_name varchar, total_msum int);
SELECT sale_year, sale_month FROM sales_info GROUP BY sale_year, sale_month; SELECT total_msum FROM sales_info WHERE total_msum < 15000;

4. CREATE TABLE client_info (client_name varchar, total_ysum int); SELECT total_ysum FROM client_info WHERE total_ysum IS NOT NULL;

5. CREATE TABLE client_info (client_name varchar, total_ysum int); SELECT client_name FROM client_info WHERE client_name like ‘R%';

6. CREATE TABLE client_info (client_name varchar, total_ysum int); SELECT * FROM client_info ORDER BY total_ysum DESC;
SELECT TOP 3 * FROM total_ysum;

7. CREATE TABLE product_info (client_name varchar, product_name1 varchar, product_name2 varchar, product_name3 varchar, total_sum int);

SELECT * FROM product_info ORDER BY client_name ASC; SELECT * FROM product_info ORDER BY total_sum DESC;
SELECT total_sum FROM product_info WHERE total_sum > 0;

Reference no: EM131826904

Questions Cloud

Prepare a trial balance for the end of the month : On January 4, Mary Markham, an attorney, opened her private law firm...Markham Law (ML). Prepare a trial balance for the end of the month

Question has four possible answers : Christie is taking a multiple-choice test in which each question has four possible answers. She knows the answers to 40% of the questions and can narrow

Probability that they are drawn in the order red : A box contains 9 red balls, 6 white balls, and 5 blue balls. If 3 balls are drawn successively from the box, determine the following:

Prepare a corrected classified balance sheet in good form : Notes payable are long-term except for the current installment due of $100,000. Prepare a corrected classified balance sheet in good form

Create database salesinformation : CREATE DATABASE salesinformation; CREATE TABLE sales_data (sale_date date, client_name varchar, product_name varchar, total_dsum int);

Approximate measure of subcutaneous body fat : Use the ice data set to see if the intramuscular temperature changes more for people with smaller Skinfold measurements.

Temperature measurements from the ice data set : Use the B1930 temperature measurements from the ice data set to see if there is evidence that any of the following differ between men and women.

Predict waist-to-hip ratio : Does the genetic marker in fusion1 predict waist-to-hip ratio (phenol where)? Fit an appropriate model to answer this question.

Create a java class that implements floating point add : For this assignment, you will be creating a Java class that implements floating point Add and Multiply. The layout of your class should look like this.

User Account

All Pages