1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Lemur [1.5K]
3 years ago
13

Using the Heather Sweeney SQL script, create and add values provided in Titanium in order to create the HSD Database. Write and

save SQL statements using a text editor (e.g., Notepad) to answer the query requests below. Although you only submit the SQL text file, you may want to test and verify the SQL statements using MS SQL Server 2012. Use comment lines as descriptors for each different SQL statement.
The text file should contain the following SQL query requests

1.List the various product numbers only once in the line item table.

2.List the number of products ordered in line item by product number.

3.List the first name, last name, and number of contacts made for each customer who live in Dallas regardless of contact type .

4.List the first name, last name and phone number for customers who purchased the video companion titled ‘Kitchen Remodeling Basics’. Use a subquery.

5. List the number of invoices for each email address where the payment is made using Mastercard and the total invoice amount is less than $100.00.

6.Use the previous SQL statement to show all records regardless of payment type or amount with 2 or more invoices.

7.Verify that the total listed in line item is accurate and correct by creating a calculated field and displaying it next to the original total field.

8.Use previous SQL statement and modify it to show grand totals by invoice number.

9.List the total number of transactions by payment type greater than 8.

10. List the grand total for each customer making payments with their Visa cards.
Computers and Technology
1 answer:
eimsori [14]3 years ago
7 0

Answer:

Check the explanation

Explanation:

1. SELECT DISTINCT ProductNumber FROM LINE_ITEM

2. SELECT ProductNumber,count(ProductNumber) FROM LINE_ITEM WHERE ProductNumber is not null

group by ProductNumber

3. SELECT LastName, FirstName, Phone FROM CUSTOMER WHERE City = 'Dallas'

5.

SELECT count(i.*) FROM Invoice i

Inner Join Line_Item li on li.invoiceNumber=i.invoicenumber

WHERE li.total<100 and i.paymenttype='Mastercard'

You might be interested in
How important are operating system in our devices?​
TiliK225 [7]

Answer:

Explanation:

An operating system is the most important software that runs on a computer. ... It also allows you to communicate with the computer without knowing how to speak the computer's language. Without an operating system, a computer is useless.

6 0
3 years ago
Read 2 more answers
Write a method that takes a RegularPolygon as a parameter, sets its number of sides to a random integer between 10 and 20 inclus
Sergio [31]

Answer:

import java.lang.Object

import java.lang.Math

public class RegularPolygon  extends java.lang.Object{

  public void randomize(RegularPolygon c){

       int min = 10, max1 = 20;

       double  min1 = 5, max1 = 12;

       double range = (max - min) + 1;

       double range1 = (max1 -min1) + 1

       int side = (Math.random() * range) + min;

       double len = (Math.random() * range1) + min1;

       c.setNumSides(side);

       c.setSideLength( len);

 }

 public static void main(String[] args) {

    RegularPolygon r = new RegularPloygon();

    randomize(r);

 }

}

Explanation:

The randomize method accepts a regular polygon class as its only parameter and assigns a random number of sides and the length of these sides with the 'Math.random' function.

5 0
3 years ago
Summary: Given integer values for red, green, and blue, subtract the gray from each value. Computers represent color by combinin
Dmitry_Shevchenko [17]

Answer:

Follows are the code to this question:

#include<iostream>//defining header file

using namespace std;// use package

int main()//main method

{

int red,green,blue,x;//declaring integer variable

cin>> red >>green>>blue;//use input method to input value

if(red<green && red<blue)//defining if block that check red value is greater then green and blue  

{

x = red;//use x variable to store red value

}

else if(green<blue)//defining else if block that check green value greater then blue  

{

x= green; //use x variable to store green value

}

else//defining else block

{

x=blue;//use x variable to store blue value

}

red -= x;//subtract input integer value from x  

green -=x; //subtract input integer value from x

blue -= x;//subtract input integer value from x

cout<<red<<" "<<green<<" "<<blue;//print value

return 0;

}

Output:

130 50 130

80 0 80

Explanation:

In the given code, inside the main method, four integers "red, green, blue, and x" are defined, in which "red, green, and blue" is used for input the value from the user end. In the next step, a conditional statement is used, in the if block, it checks red variable value is greater than then "green and blue" variable. If the condition is true, it will store red variable value in "x", otherwise, it will goto else if block.

  • In this block, it checks the green variable value greater than the blue variable value. if the condition is true it will store the green variable value in x variable.
  • In the next step, else block is defined, that store blue variable value in x variable, at the last step input variable, is used that subtracts the value from x and print its value.      
5 0
4 years ago
About computer in manufacturing​
Karolina [17]


Computer-integrated manufacturing is the manufacturing approach of using computers to control the entire production process


7 0
3 years ago
Please answer today 20 pts!!
Lina20 [59]

Answer:

give each member their own translator and a seprate workspace

sry bout the spelling

Explanation:

3 0
3 years ago
Other questions:
  • Your desktop computer monitor is not displaying a picture. What would you do to troubleshoot the problem?
    9·2 answers
  • An engineer is assigned to replace an older data-grade autonomous wireless network with a cisco controllerbased wireless network
    6·1 answer
  • which of the following are used on cable trays to protect the cable insulation from direct sunlight? a. barrier strips b. solid
    5·1 answer
  • What role do mobile devices play in shaping the world?
    5·2 answers
  • list the sixth external parts of a computer system and identify which are output and which are input devices
    14·2 answers
  • Which of the following is a file on the host computer used for temporary memory storage when a sudden surge in memory requiremen
    9·1 answer
  • Parts of a Computer
    13·2 answers
  • For which of the following values of A and B will the expression A || B be true?
    15·1 answer
  • Match each definition with the term it describes. A(n) ______ provides identification and addressing information for computers a
    5·1 answer
  • What is the 6 example of computer hardware and explain​
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!