Write sql queries, PL-SQL Programming

Assignment Help:

Write SQL queries to solve the following specifications. Include the query AND THE OUTPUT.  A screen dump of the output is acceptable. Show as many rows as you can. A screen dump is usually done via the ALT/PRNTSCRN command sequence.

1.  Display full details for all cars

2.  Display the model name and car group name for all models. Order by car group name in alphabetical order.

3.  Display full details for all bookings where the amount due has not yet been entered.

4.  Display the customer number for all customers who have ever rented a car. Do not display duplicates.

5.  Display the total number of miles travelled for each booking and sort the output by the number of miles travelled in descending order. Label the output: MILES TRAVELLED

INTERESTING EXERCISE: Is it possible to sort using an alias?

6.  Display full details for all bookings where the miles out was greater than 300 and the booking has been paid.

7.  Display full details for any customer  who

1)  Has an address where the second character is a 2 and whose customer number has 3 as the second character  OR

2)  Has a customer number greater than or equal to 400 and lives in a county whose name begins with an H

8.  Display the rate per mile for all cargroups where the cargroup name is A1 or A2 and the rate per day is either 25 or 33. Find a way of optimising your code so that the complete SQL statement has only logical operator (AND, OR, NOT).

9.  Display the customer number and the  booking number for all bookings. Order by booking number within customer number (both ascending).  Your query must not contain the word WHERE.

10. Using a traditional join (WHERE CLAUSE) display the customer number and the  booking number for all bookings. Order by booking number within customer number (both ascending).  Your query must use the alias A for I_BOOKING and the alias B for I_CUSTOMER.


Related Discussions:- Write sql queries

Python function, This task involves developing some functions that extract ...

This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

Design a script and integrate procedures, Initial thought process: Design...

Initial thought process: Design a script which was simple and user friendly. Integrate procedures/functions to extract data under the hood. I focused on giving the user the opt

Defining and declaring collections, Defining and Declaring Collections T...

Defining and Declaring Collections To create the collections, you must define a collection type, and then declare the collections of that type. You can define the VARRAY types a

Manipulating local collections - pl/sql, Manipulating Local Collections ...

Manipulating Local Collections Within PL/SQL, to manipulate the local collection, by using the  TABLE and CAST operators . The operands of CAST are a collection declared locally

Truth tables , Truth Tables: However in propositional logic - here we ...

Truth Tables: However in propositional logic - here we are restricted to expressing sentences and where the propositions are true or false - so we can check where a particular

Some varray examples-manipulating collections, Some Varray Examples In S...

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Scoping-naming conventions, Scoping Within the similar scope, all the de...

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

Heap sort algorithm in pl sql, I want to implement heap sort algorithm in p...

I want to implement heap sort algorithm in pl sql please share the source code for guidance

Effects of null for table expression, Effects of NULL for Table Expression ...

Effects of NULL for Table Expression Here's an important distinction between expressions denoting tables and expressions denoting multisets of rows: a table expression cannot

Second step at defining type sid in sql, Second Step at defining type SID i...

Second Step at defining type SID in SQL CREATE TYPE SID AS VARCHAR(5) ; Explanation: TYPE SID announces that a type named SID is being defined to the system.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd