Question: I am doing an OPIM assignment on a computer program called DB Browser. Help me answer the highlighted question. The other photos are for context

I am doing an OPIM assignment on a computer program called DB Browser. Help me answer the highlighted question. The other photos are for context of what the Data that is already in there is. Feel free to post questions for clarification. I need the written sql commands to type in the blank space shown below on image 3 to execute the function asked by the question.

I am doing an OPIM assignment on a computer program called DB

Browser. Help me answer the highlighted question. The other photos are for

context of what the Data that is already in there is. Feel

free to post questions for clarification. I need the written sql commands

Table: OfficeRentals \begin{tabular}{|c|c|c|c|c|c|c|} \hline & RentalID & LastName & FirstName & OfficeNumber & PrimarySpecialty & MoveInDate \\ \hline & Filter & Filter & Filter & Filter & Filter & Filter \\ \hline 1 & 1 & Hennessy & James & 220 & Pediatrics & 2013-07-01 \\ \hline 2 & 2 & Plice & Rick & 305 & Family Medicine & 2011-03-15 \\ \hline 3 & 3 & Dyer & Daniel & 115 & Pediatrics & 2017-04-01 \\ \hline 4 & 4 & Singh & Robyn & 210 & Family Medicine & 20160601 \\ \hline 5 & 5 & Norman & Steven & 230 & Internal Medicine & 20101215 \\ \hline 6 & 6 & Ansari & Randy & 180 & Dermatology & 2015-04-01 \\ \hline 7 & 7 & Pelayo & Kumara & 210 & Family Medicine & 20100515 \\ \hline 8 & 8 & Bolden & Victor & 215 & Podiatry & 2019-01-15 \\ \hline 9 & 9 & Fowler & Seth & 140 & Allergy \& Immunology & 20190323 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Invoices & & CREATE TABLE "Invoices" ( "InvoiceID" INTEGER, "Month" TEXT, "InvoiceDate" TEXT, "BillDueDate" TEXT, "RentalRate" NUMERIC, "RentPaid" NUMERIC, "PaymentDate" TEXT, "FKRentalID" INTEGER, PRIMARY KEY("InvoiceID") ) \\ \hline InvoiceID & INTEGER & "InvoiceID" INTEGER \\ \hline Month & TEXT & "Month" TEXT \\ \hline InvoiceDate & TEXT & "InvoiceDate" TEXT \\ \hline BillDueDate & TEXT & "BillDueDate" TEXT \\ \hline DentalRate & NUMERIC & "RentalRate" NUMERIC \\ \hlineD RentPaid & NUMERIC & "RentPaid" NUMERIC \\ \hline PaymentDate & TEXT & "PaymentDate" TEXT \\ \hline FKRentaliD & INTEGER & "FKRentalID" INTEGER \\ \hline OfficeRentals & & CREATE TABLE "OfficeRentals" ( "RentalID" INTEGER, "LastName" TEXT, "FirstName" TEXT, "OfficeNumber" INTEGER, "PrimarySpecialty" TEXT, "MoveInDate" TEXT, PRIMARY KEY("RentalID") ) \\ \hline RentalID & INTEGER & "RentalID" INTEGER \\ \hline DastName & TEXT & "LastName" TEXT \\ \hline FirstName & TEXT & "FirstName" TEXT \\ \hline officenumber & INTEGER & "OfficeNumber" INTEGER \\ \hline Primaryspecialty & TEXT & "PrimarySpecialty" TEXT \\ \hline MoveInDate & TEXT & "MoveInDate" TEXT \\ \hline \end{tabular} Q4 Rent Payments by Specialty (2 pts) How much was brought in for rental revenue by primary specialty? Q4 Capture a screenshot that shows the SQL commands you used, results window and include the log text that says that Execution finished without errors. DB Browser for SQLite - Ci\Users\derek\Desktop\MedicalRentals.db File Tools Help Open Project (8) Attach Database Close Database Database Structure Browse Data - GWrite Changes Revert Changes Execute SQL (1) SQL 1 1 Table: OfficeRentals \begin{tabular}{|c|c|c|c|c|c|c|} \hline & RentalID & LastName & FirstName & OfficeNumber & PrimarySpecialty & MoveInDate \\ \hline & Filter & Filter & Filter & Filter & Filter & Filter \\ \hline 1 & 1 & Hennessy & James & 220 & Pediatrics & 2013-07-01 \\ \hline 2 & 2 & Plice & Rick & 305 & Family Medicine & 2011-03-15 \\ \hline 3 & 3 & Dyer & Daniel & 115 & Pediatrics & 2017-04-01 \\ \hline 4 & 4 & Singh & Robyn & 210 & Family Medicine & 20160601 \\ \hline 5 & 5 & Norman & Steven & 230 & Internal Medicine & 20101215 \\ \hline 6 & 6 & Ansari & Randy & 180 & Dermatology & 2015-04-01 \\ \hline 7 & 7 & Pelayo & Kumara & 210 & Family Medicine & 20100515 \\ \hline 8 & 8 & Bolden & Victor & 215 & Podiatry & 2019-01-15 \\ \hline 9 & 9 & Fowler & Seth & 140 & Allergy \& Immunology & 20190323 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Invoices & & CREATE TABLE "Invoices" ( "InvoiceID" INTEGER, "Month" TEXT, "InvoiceDate" TEXT, "BillDueDate" TEXT, "RentalRate" NUMERIC, "RentPaid" NUMERIC, "PaymentDate" TEXT, "FKRentalID" INTEGER, PRIMARY KEY("InvoiceID") ) \\ \hline InvoiceID & INTEGER & "InvoiceID" INTEGER \\ \hline Month & TEXT & "Month" TEXT \\ \hline InvoiceDate & TEXT & "InvoiceDate" TEXT \\ \hline BillDueDate & TEXT & "BillDueDate" TEXT \\ \hline DentalRate & NUMERIC & "RentalRate" NUMERIC \\ \hlineD RentPaid & NUMERIC & "RentPaid" NUMERIC \\ \hline PaymentDate & TEXT & "PaymentDate" TEXT \\ \hline FKRentaliD & INTEGER & "FKRentalID" INTEGER \\ \hline OfficeRentals & & CREATE TABLE "OfficeRentals" ( "RentalID" INTEGER, "LastName" TEXT, "FirstName" TEXT, "OfficeNumber" INTEGER, "PrimarySpecialty" TEXT, "MoveInDate" TEXT, PRIMARY KEY("RentalID") ) \\ \hline RentalID & INTEGER & "RentalID" INTEGER \\ \hline DastName & TEXT & "LastName" TEXT \\ \hline FirstName & TEXT & "FirstName" TEXT \\ \hline officenumber & INTEGER & "OfficeNumber" INTEGER \\ \hline Primaryspecialty & TEXT & "PrimarySpecialty" TEXT \\ \hline MoveInDate & TEXT & "MoveInDate" TEXT \\ \hline \end{tabular} Q4 Rent Payments by Specialty (2 pts) How much was brought in for rental revenue by primary specialty? Q4 Capture a screenshot that shows the SQL commands you used, results window and include the log text that says that Execution finished without errors. DB Browser for SQLite - Ci\Users\derek\Desktop\MedicalRentals.db File Tools Help Open Project (8) Attach Database Close Database Database Structure Browse Data - GWrite Changes Revert Changes Execute SQL (1) SQL 1 1

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 General Management Questions!

I am doing an OPIM assignment on a computer program called DB Browser. Help me answer the highlighted question. The other photos are for context of what the Data that is already in there is. Feel...

Directions for part 2 of your assignment: Select 3 of the critical incidents below and analyze them. Your analysis should contain at least three scholarly references each that pertain directly to the...

Please help me answer this question. I would appreciate alot! 100% + Lab Assignment 3 The Coordinate Distance Calculator Due Date (a two-week LA) Sections(540,543,544,545) 3/3/21 @11:59:59pm Concepts...

Screen shot of the 4 panes you see when you run the dns.cap file in Wireshark. Question 4.3.1: In Packet No. 28, what is the Source Port of the UDP data? (Hint: What does UDP stand for?) Question...

CHA P TER 9 Understanding Software: A Primer for Managers 1. INTRODUCTION L E A R N I N G O B J E C T I V E S 1. Recognize the importance of software and its implications for the rm and strategic...

images is our lesson. Read the 4th-7th images for better understanding. WEEK 2 TLE 8 -Computer System Servicing - LEARNING TASKS Basahing mabuti ang mga aralin sa Leap Week 2. Sagutan sa hiwalay na...

INTRODUCING THE WIRESHARK NETWORK ANALYZER 1.1. Work description When diagnosing network problems and studying the behavior of network applications, traffic analysis data is an invaluable source of...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

help with project Wireshark Assignment 1. Overview Wireshark is an open source application freely available on the Internet that allows you to capture packets as they appear at the network adaptor...

The figure below shows a soils body subjected to principal stresser Determine the stresses on plane B-B. +20 kN/m 4014 B 4 B 30 40KN/m 30 0042 28 20kN/m

QUESTION 6/15 What value would be returned based on the formula in Cell A49? 43 npab 44 npce 45 npfo 46 npbb 47 norp 48 49 =COUNTIF(A43:A47,"NP*") Image not displaying? 0 1 2 3 4 A 5 Q

Joel's car broke down on a dark, rainy night. Along came Andy in his four - wheel drive truck with tools and supplies in the back. Joel didn't have any credit cards and had only $ 3 . 2 5 cash, so...

The annual demand for an item is 1,700 units. The order cost is $7. Unit cost is $8 and the unit holding cost per year is 18% of the item's value. The order quantity is 125 units. What are the total...