Question: Write an Oracle SQL query that will count working days between the start date and end date and output will be like the below one

Write an Oracle SQL query that will count working days between the start date and end date and output will be like the below one :

Project_id Start Date End Date Count of Working Days
1123 June 12 2021 August 28 2021 55
3344 September 23 2020 September 27 2020 3
5566 May 13 2021 June 12 2021 22
2543 March 30 2021 January 1 2022 199
2267 October 2 2021 November 2 2021 21
9089 January 22 2021 March 1 2021 26
6745 April 24 2021 May 20 2021 19

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

The GCS database must support all of GCSs operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a...

Q:

Here are the steps you need to go through to do the project: Given the business rules above, create a logical-level Crows Foot ERD using Visio. Show all original entities and any associative entities...

Q:

The GCS database must support all of GCSs operations and information requirements. A basic description of the main entities follows: The employees of GCS must have an employee ID, a last name, a...

Q:

Instructions: two written paragraphs for each numbered question, 10 sentences per paragraph. providing good support from Chapter 6 helps strengthen your answer, opinions are welcomed. 1. what type of...

Q:

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

Q:

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

Q:

Please complete Task0-task 9 (SQL only) Scenario and Database Model: InstantStay InstantStay is the new online marketplace to find accommodation in various cities and states. It focuses on gathering...

Q:

1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: Each Job is for a specific customer and there can be more than one job per customer. The...

Q:

Project Steps: 1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: Each Job is for a specific customer and there can be more than one job...

Q:

1. Database Design 1.1. Design and create a database in third normal form based on the following requirements: Each Job is for a specific customer and there can be more than one job per customer. The...

Q:

The condensed balance sheet as of December 31, 2014, for Van Den Boom Enterprises follows: Revenues and expenses (other than amortization) are predicted to be $65,000 and $20,000, respectively, for...

Q:

Fiona Parsons, aged 35, lives in Melbourne and works as a management consultant. She is employed by Staedler Ltd, an American company specialising in the development of information systems for the...

Q:

The R - value is always a value between ( or including ) - 1 and 1 . False, the R - value is always a value between ( or including ) 0 and 1 . False, the R - valug is always a value between for...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

What are Measures in OLAP Cubes?

Q:

How do OLAP Databases provide for Drilling Down into data?

Q:

How are OLAP Cubes different from Production Relational Databases?