Question

In: Computer Science

1. Write the statement that will display all of the information in the PetOwner table using...

1. Write the statement that will display all of the information in the PetOwner table using the asterisk (*) notation.

2. Write the statement that will display all of the information in the PetOwner table without using the asterisk (*) notation.

3. Write the statement that will display the first and last names of the owners in that order.

4. Write the statement to display the breed, type and DOB of all pets having a type of Cat.

5. Write the statement to display the names of the pets that have an annotated birthdate.

6. Write the statement to display all of the listed pet breeds.

Solutions

Expert Solution

Q1. Write the statement that will display all of the information in the PetOwner table using the asterisk (*) notation.
Answer:-------
SELECT
* FROM PetOwner ;

Q2. Write the statement that will display all of the information in the PetOwner table without using the asterisk (*) notation.
Answer:-------
SELECT
OwnerID, OwnerFirstName, OwnerLastName, OwnerEmail, OwnerPhone FROM PetOwner ;

Q3. Write the statement that will display the first and last names of the owners in that order.
​​​​​​​Answer:-------
SELECT
OwnerFirstName, OwnerLastName FROM PetOwner ORDER BY OwnerFirstName, OwnerLastName ;

Q4. Write the statement to display the breed, type and DOB of all pets having a type of Cat.
​​​​​​​Answer:-------
SELECT
PetBreed, PetType, PetDOB FROM Pet
WHERE
PetType = ‘Cat' ;

Q5. Write the statement to display the names of the pets that have an annotated birthdate.
​​​​​​​Answer:-------
SELECT PetName FROM Pet
HAVING DISTINCT
PetDOB ;

Q6. Write the statement to display all of the listed pet breeds.
​​​​​​​Answer:-------
SELECT
PetBread FROM Pet ;


Related Solutions

1- Write a program that will display the following series of integers using iterative statement of...
1- Write a program that will display the following series of integers using iterative statement of your choice, and terminate the iteration once it is larger than 200. 1, 3, 7, 13, 21, 31, 43, … use only C++!!
Write an XQUERY to display the information for all students who are not Malaysians or older...
Write an XQUERY to display the information for all students who are not Malaysians or older than 25 <root> <students>    <element>        <ID>100345</ID>        <Nationality>USA</Nationality>        <Program>ICT</Program>        <age>23</age>        <name>John</name>    </element>    <element>        <ID>100876</ID>        <Nationality>MALAYSIA</Nationality>        <Program>CS</Program>        <age>28</age>        <name>Awang</name>    </element>    <element>        <ID>100257</ID>        <Nationality>AUSTRALIA</Nationality>        <age>25</age>        <name>Alex</name>    </element> </students> </root>
Question 1. Write the statement to increase the invoice_total by 25% using the INVOICES table for...
Question 1. Write the statement to increase the invoice_total by 25% using the INVOICES table for all vendors whose vendor_id is less than 100. Question 2. Write the statement to answer the following question: What is the total of the invoice_total amounts after the update. I need your statement and the result stated here. Question 3. Write the statements to list the customer ID and Order ID from the ORDERS table for all orders with order id greater than 700....
Using python Write a program that displays all of states in the U.S. and display each...
Using python Write a program that displays all of states in the U.S. and display each state that begins with the letter A.
Java Program Use for loop 1.) Write a program to display the multiplication table of a...
Java Program Use for loop 1.) Write a program to display the multiplication table of a given integer. Multiplier and number of terms (multiplicand) must be user's input. Sample output: Enter the Multiplier: 5 Enter the number of terms: 3 5x0=0 5x1=5 5x2=10 5x3=15 2 Create a program that will allow the user to input an integer and display the sum of squares from 1 to n. Example, the sum of squares for 10 is as follows: (do not use...
1. Write a for loop that will display all of the multiples of 3, one per...
1. Write a for loop that will display all of the multiples of 3, one per line. The starting point is a variable called lower, and the ending point is an integer called upper, inclusive. The "lower" and "upper" variables have been properly declared and assigned values where the value of lower is less than or equal to the value of upper. Declare any other variables that are needed. 2. Write a "while" loop that does the same thing as...
Using If-Else conditional statement write a Visual Basic Program to display: (i) “STOP” if the user...
Using If-Else conditional statement write a Visual Basic Program to display: (i) “STOP” if the user enters “R” (ii) “CAUTION” if the user enters “Y” (iii) “GO” if the user enters “G” (iv) “Invalid” if the user enters any other character
For the following sample, display the data using a frequency distribution table and then using a...
For the following sample, display the data using a frequency distribution table and then using a histogram . Assume the data is continuous and measured on a ratio scale. 23 21 18 17 17 15 20 3 4 28 16 15 15 15 27 2 3 15 16 16 a) How would you describe the shape of the distribution? b) Which is the most appropriate measure of central tendency? c) Calculate the most appropriate measure of central tendency.
PLEASE USING THIS INFORMATION FILL OUT ALL COLUMNS COMPLETELY IN THE TABLE MARKED AS (*******) 1)...
PLEASE USING THIS INFORMATION FILL OUT ALL COLUMNS COMPLETELY IN THE TABLE MARKED AS (*******) 1) Life Period of the Equipment = 4 years 8) Sales for first year (1) $    200,000 2) New equipment cost $        (200,000) 9) Sales increase per year 5% 3) Equipment ship & install cost $          (35,000) 10) Operating cost: $   (120,000) 4) Related start up cost $             (5,000)     (60 Percent of Sales) -60% 5) Inventory increase $            25,000 11) Depreciation (Straight Line)/YR $    ...
I want the program to use 1- D array and display a table as output. Write...
I want the program to use 1- D array and display a table as output. Write a script to simulate the rolling of two dice. The script should use Math.random to roll the first die and again to roll the second die. The sum of the two values should then be calculated. [Note: Since each die can show an integer value from 1 to 6, the sum of the values will vary from 2 to 12, with 7 being the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT