HIT 234 - SQL Statements For Creating Tables And Insert Data - Definition Of Rep Stands For Repetition - IT/Computer Science Assignment Help

Assignment Task -

Part A - Single and multiple table queries

1. List in ascending order the Last Names of all borrowers with Card Number less than 150.

2. What are the records of those loans between 3 June 2014 and 8 Mar 2018? ? The output should include the name of the cardholder, and title of the book ? List in ascending order by last name and first name 

3. Find the total numbers of loans with last name beginning with D through E (including E);  include last name beginning with Q as well as Z also. 

4. Find all borrowers for a loan that have the Date-in before 15-March-15 and the Card number  between 100 and 300 in Karama or Darwin. 

5. Find the number of loans, which have been made from each branch?

Part B – Table and Advanced Queries

1. The following Gym application database for weight session recording is as follows. Write  and run SQL statements for creating the Occurrence_Exercise table.

2. Write an SQL statement that will into Occurrence_Exercise table only. ? Definition of rep stands for repetition.

Create the following queries: 

3. Find the exercise which contains the maximum total weight lifted 

 Show: Exercise, Maximum weight 

 Ensure you show captions for each of the columns 

 Hint: you would need to consider the number of times the weight is lifted and weight e.g. rep multiplied by attempt multiplied by the weight 

4. Find the exercise that the user was not able to complete 3 attempts in, or the exercise that the  user has not attempted. 

 Show appropriate columns 

 List in ascending order exercise type 

 Do not show repeated names 

 Ensure you show captions for each of the columns

This IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.