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...
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...
1. Write a bash command that will display the value of all environment variables defined in...
1. Write a bash command that will display the value of all environment variables defined in your shell process, sorted in alphabetical order, and numbered. Here is a sample of the type of output your command should produce: 1 } 2 ALSA_CONFIG_PATH=/etc/alsa-pulse.conf 3 AUDIODRIVER=pulseaudio 4 BASH_FUNC_mc%%=() { . /usr/share/mc/mc-wrapper.sh 5 COLORTERM=1 2. Write a bash command that will display the value (and only the value) of the JAVA_ROOT environment variable. Here is a sample of the type of output your...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT