WEEK 3 ASSIGNMENT This assignment contains two parts. You must complete Part I before moving on to Part II.Part I:Using the table you previously worked on, complete the following exercise:Insert a row into your student table where the last name is "Parker", first name is "Sam" and the ZIP code is "68134". You can determine the values for the remaining columns.Select a row from your student table where the last name equals "Parker". Select a row from your student table where the ZIP code is less than "68134".Select the student first and last name from the student table order by the state column. Part II:Complete the following exercise:Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state.Using your student table select all students with ZIP codes between “23164” and “98164”.Using your student table select all students where states are in Florida and New York.Using your student table select all students where the last name starts with an “S” and is at least three characters in length.

Note: Since your question contain multiple question having multiple sub -part . but we can answer…

Answered: This assignment contains two parts. You…

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks

Related questions

Question

100%

WEEK 3 ASSIGNMENT

This assignment contains two parts. You must complete Part I before moving on to Part II.

Part I:

Using the table you previously worked on, complete the following exercise:

Insert a row into your student table where the last name is "Parker", first name is "Sam" and the ZIP code is "68134". You can determine the values for the remaining columns.
Select a row from your student table where the last name equals "Parker".
Select a row from your student table where the ZIP code is less than "68134".
Select the student first and last name from the student table order by the state column.

Part II:

Complete the following exercise:

Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state.
Using your student table select all students with ZIP codes between “23164” and “98164”.
Using your student table select all students where states are in Florida and New York.
Using your student table select all students where the last name starts with an “S” and is at least three characters in length.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

Part II:

Complete the following exercise:

Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state.
Using your student table select all students with ZIP codes between “23164” and “98164”.
Using your student table select all students where states are in Florida and New York.
Using your student table select all students where the last name starts with an “S” and is at least three characters in length.

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.