Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Assignment
Garden Glory is a partnership that provides gardening and yard maintenance services to individuals and organizations. Garden Glory is owned by two partners, who employ two office administrators and a number of full- and part-time gardeners. Garden Glory will provide one-time garden services, but it specializes in ongoing service and maintenance. Many of its customers have multiple buildings, apartments, and rental houses that require gardening and lawn maintenance services.
Below is a sample list of owners, properties, and services that Garden Glory collects about for its business operation.
1. Write an SQL statement to list the names of employees who have worked on a property owned by a Corporation.
2. Write an SQL statement to show the name and sum of HoursWorked for each employee.
3. Write an SQL statement to show the sum of HoursWorked for each ExperienceLevel of EMPLOYEE. Sort the results by ExperienceLevel in descending order.
4. Write an SQL statement to show the sum of HoursWorked for each Type of OWNER but exclude services of employees who have an ExperienceLevel of Junior and exclude any Type with less than three members.
The BIRTHDAY_DISTRIBUTION table consists of every day of the year, from January 1 to December 31. Create and populate the BIRTHDAY_DISTRIBUTION table by using the following SQL statements.
List the movies which have more than one director. Include the year, title, last and first name of directors. Sort the output by last name within title. (use subquery)
Write a command that will remove the Jones that lives in Orange from the Customer table .Write the SQL DDL to create the database that contains each of the relations shown in the above ERD.
Use the data on the Christensen worksheet in the range A1:J19 to create a PivotChart on a new sheet. Use the Type, Issue Price, and Est. Value fields and the default locations. Find the average issue price and average estimated value.
Display all employees' names, last name first, and then first name, and hire date. Order the results by employee name, last name first, and then first name.
Select the form and switch between the views (Forms, Layout, and Design) to change the properties or the form's appearance as desired.
Write an SQL select statement to list all double or family rooms with a price less than $255 per night in ascending order of price.
Explain how you will go about developing this database. Provide at least four queries that answer some of the questions asked by the end users.
Write SQL expression for the following questions about the security aspects of above database. Student can view all the information in the course and instructor tables except for InstructorId.
Task one will provide a relational database implementation of the sample solution from the first assignment. This should be done using CASE software (the choice will be up to you).
1. Write a SQL statement to display Student's First and Last Name. 2. Write a SQL statement to display the Major of the STUDENT with no duplications. Do not display student names. 3. Write a SQL statement to display the First and Last Name of studen..
Credit will be given to queries that are not trivial, for example, "SELECT * FROM Tablename" is unlikely to gain more than one mark. SQL Developer can be used to produce the queries and populate the tables.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd