Which of the following calculates a 10% commission on the values in the Sales field and then stores the results in the Commission field? a. SELECT Year, Sales, Commission = Sales * 0.1 FROM dbo.TrentSales b. SELECT Year, Sales, AS Commission = Sales * 0.1 FROM dbo.TrentSales c. SELECT Year, Sales, Sales * 0.1 = Commission FROM dbo.TrentSales d. SELECT Year, Sales, Sales * 0.1 AS Commission FROM dbo.TrentSales

Which of the following calculates a 10% commission on the values in the Sales field and then stores the results in the Commission field? a. SELECT Year, Sales, Commission = Sales * 0.1 FROM dbo.TrentSales b. SELECT Year, Sales, AS Commission = Sales * 0.1 FROM dbo.TrentSales c. SELECT Year, Sales, Sales * 0.1 = Commission FROM dbo.TrentSales d. SELECT Year, Sales, Sales * 0.1 AS Commission FROM dbo.TrentSales

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter12: Database Queries With Sql

Section: Chapter Questions

Problem 12RQ

See similar textbooks

Similar questions

Which of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? Me.CompanyDataSet.Fill(Me.Sales) Me.SalesBindingSource.Fill(Me.CompanyDataSet) Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)
Which of the following is not a valid SELECT statement? SELECT lastname, firstname FROM customers; SELECT * FROM orders; Select FirstName NAME from CUSTOMERS; SELECT lastname Last Name FROM customers;
Which of the following calculates the average of the values in the OnHand field? a. SELECT AVERAGE(OnHand) AS Available FROM dbo.Inventory b. SELECT OnHand.AVG AS Available FROM dbo.Inventory c. SELECT AVG(OnHand) AS Available FROM dbo.Inventory d. SELECT AVG.OnHand AS Available FROM dbo.Inventory
Which of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? a. Me.CompanyDataSet.Fill(Me.Sales) b. Me.SalesBindingSource.Fill(Me.CompanyDataSet) c. Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) d. Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)
Which of the following statements would create a UNION between all of the countries we have customers, employees, or invoices in? SELECT countryFROM invoiceUNIONSELECT countryFROM customerUNIONSELECT countryFROM employee; SELECT billing_countryFROM invoiceSELECT countryFROM customerSELECT countryFROM employeeUNION; SELECT billing_countryFROM invoiceSELECT countryFROM customerSELECT countryFROM employee; SELECT billing_countryFROM invoiceUNIONSELECT countryFROM customerUNIONSELECT country
Which of the following is not a valid SELECT statement?a. SELECT STDDEV(retail)FROM books;b. SELECT AVG(SUM(retail))FROM ordersNATURAL JOIN orderitems NATURAL JOIN booksGROUP BY customer#;c. SELECT order#, TO_CHAR(SUM(retail), '999.99')FROM orderitems JOIN books USING(isbn)GROUP BY order#;d. SELECT title, VARIANCE(retail-cost)FROM booksGROUP BY pubid;
SELECT COUNT(INV_NUMBER) AS 'Total Invoices', SUM(TOTAL_PRICE) AS 'Total Sales', MIN(TOTAL_PRICE) AS 'Minimum Customer Purchases', MAX(TOTAL_PRICE) AS 'Largest Customer Purchases', ROUND(AVG(TOTAL_PRICE), 2) AS 'Average Customer Purchases'FROM (SELECT CUS_CODE, LINE.INV_NUMBER AS INV_NUMBER, ROUND(SUM(LINE.LINE_PRICE * LINE.LINE_UNITS), 2) AS TOTAL_PRICEFROM INVOICE, LINE WHERE INVOICE.INV_NUMBER = LINE.INV_NUMBER GROUP BY CUS_CODE, LINE.INV_NUMBERORDER BY CUS_CODE, LINE.INV_NUMBER)INVOICELINE; i use this code but it didn't show the same value as in the question
Which of the following is equivalent to WHERE attribute NOT BETWEEN 100 AND 1000? a. WHERE attribute < 100 OR attribute > 1000 b. WHERE attribute >= 100 AND attribute <= 1000 c. WHERE attribute >= 100 OR attribute <= 1000 d. WHERE attribute = 100 OR attribute = 1000
Which of the following queries identifies other customers who were referred to JustLee Books by the same person who referred Jorge Perez?a. SELECT customer# FROM customersWHERE referred = (SELECT referred FROM customersWHERE firstname = 'JORGE'AND lastname = 'PEREZ');b. SELECT referred FROM customersWHERE (customer#, referred) = (SELECT customer#FROM customers WHERE firstname = 'JORGE'AND lastname = 'PEREZ');c. SELECT referred FROM customersWHERE (customer#, referred) IN (SELECT customer#FROM customers WHERE firstname = 'JORGE'AND lastname = 'PEREZ');d. SELECT customer# FROM customersWHERE customer# = (SELECT customer#FROM customers WHERE firstname = 'JORGE'AND lastname = 'PEREZ');
My resualt has error? SELECT last_name,customer_number2 from CUSTOMERS WHERE REFERRED is not null;SELECT last_name,customer_number*ERROR at line 1:ORA-00904: "CUSTOMER_NUMBER": invalid identifier List all customers who were referred to the bookstore by another customer. List eachcustomer’s last name and the number of the customer who made the referral.
Which of the following will select the State and Sales fields from the Stores table? a. SELECT State AND Sales FROM Stores b. SELECT State OR Sales FROM Stores c. SELECT State, Sales FROM Stores d. SELECT ONLY State, Sales FROM Stores
Which of the following is a valid SELECT statement? a. SELECT TITLES TITLE! FROM BOOKS; b. SELECT customer# FROM books; c. SELECT title AS Book Title from books; d. all of the above