4. Find the names of patients who have a prescription that contains the medicine called Panadol. 5. Find the average price of medicines 6. Find total price of medicines prescribed for a patient called Adam. 7. Find the names of the patients who have prescriptions from the 'Well Nutrition' clinic

Q: Suppose 59% of the customers at Pizza Palooza order a square pizza, 76% order a soft drink, and 30%…

A: Dear Student, As Probability of ordering a square pizza = P(A) = 0.59 Probability of ordering a soft…

Q: ind the names of all employees who earn more than every employee of Small Bank Corporation. 8.…

A: I have answered QUERRY Below:

Q: Four married couples have bought 8 seats in the same row for a concert. In how many different ways…

A: GIVEN: Four married couples have bought 8 seats in the same row for a concert. In how many different…

Q: 1.Find the marks in increasing order of all students a) SELECT reg#, marks FROM student ORDER BY…

A: Given that 1.Find the marks in increasing order of all students a) SELECT reg#, marks FROM student…

Q: that reads ten sets of four grades, prints the weighted average of each set, and prints the…

A: To implement this, you can store all the scores in an array which will be useful in reusability

Q: A store purchased x packages of AAA batteries at $5 per package and y packages of AA batteries at $7…

A: GIVEN: A store purchased x packages of AAA batteries at $5 per package and y packages of AA…

Q: i. Get all employees who have salary less than ‘Ward’ salary. ii. Get all employees data who belong…

A: Fetch the Ward salary Use this result for comparison as subquery and the query looks as follows…

Q: Suppose the cover price of a book is $24.95, but bookstores get a 40% discount. Shipping costs $3…

A: Algorithm: Start Set totalUnits=60 Set perbookPrice=24.95 Compute:        totalbookPrice=…

Q: Suppose the cover price of a book is $24.95, but bookstores get a 40% discount. Shipping costs $3…

A: #finding cost after discount of 40%discounted_price = 60*24.95 - 60*24.95*0.4  #find shipping cost…

Q: 4. Suppose a company has employee annual salary data as follows. - For the interval $\$ 1$ to $\$…

A: the answer is given below:-

Q: (b who have reserved a red boat. ) Find the names and ages of sailors (c) have reserved a red and a…

A: b) Πsname,Πage,(σcolor='red'(Sailors ⨝ Reserves ⨝ Boats))

Q: 1- Suppose you have the information of sales (la) of poultry factory (elga J),contain several…

A: Answer is given below .

Q: 1- Suppose you have the information of sales (la) of poultry factory (elgall Jasza) ,contain several…

A: Required: excel

Q: 3- Suppose you have the information of some of chickens farms (F1, F2) as fallow: chicken dilscount…

A: Note: since your question contain multiple part but we can answer only first 3-sub parts due to our…

Q: Q4: The following table: All the following table shows the frequency distribution. The monthly…

A: Given:

Q: Q4: The following table: All the following table shows the frequency distribution. The monthly…

A: GIVEN:

Q: Given the following salaries in $1,000, the average salary is and the most common salary is…

A: Answer :  total salary is given = $1000 We have given number of salaries count = 8  Salaries : 50 ,…

Q: *: To find the largest profit among companies, we use the function all mentioned

A: SQL Functions Tasks in SQL Server are web-based objects that contain a set of SQL statements for…

Q: *: To find the largest profit among companies, we use the function all mentioned Great Маx Min…

A: To find the largest profit among the companies, we use the function Max. Because by taking the…

Q: 3. To check whether a hospital ward is to con the table given below.

A: QUESTION NO-3 It can be solved using simple if-else statements. #include <iostream> using…

Q: Find the max profit of books in each category. 2- Find out how many books are in each order, sort…

A: SELECT CATEGORY, MAX(PROFIT) FROM BOOKS GROUP BY CATEGORY

Q: From worksheet sheet3, in cell C11, find how many Employees having allowance more than 20 gets 1st…

A: The given problem is related to MS-Office-> Excel  formula where the requirement is to find the…

Q: The following data give the starting salary for students who recently graduated from a local…

A: Answer 1. Linear model can be written as: Y' = 24328 + 3027*X1 + 6684*X2

Q: Assume now that there are 12 people initially on the yacht with 6 women and 6 men, and that…

A: Given there are 12 people. Among them, there are 6 men and 6 women. 6 people went for exploration.…

Q: The sales in a store are normally distributed with a mean of $10,000 and a standard deviation of…

A:

Q: In how many ways can a teacher arrange eight students in a row, including the first, second, and…

A: A.    10080 ways B. 30240 ways

Q: In a city there is a mini market called B-Mart that sells various types of snack. Specified min_sup…

A:

Q: From worksheet sheet3, in cell E11, find the sum of all Total Sales for 2nd half Bonus which are…

A: The given problem is related to MS Excel where the formula is to be used to solve the problem using…

Q: [Question-2] Use a one-dimer salespeople on a their gross sales f week receives $20

A: Code: using System;  namespace ConsoleApplication11 {     internal class Program     {…

Q: 5) If we have the following relationship Enrolment Student Course Student number Student name Course…

A: Given: We are given two entities and a relationship between them.  Goal: We have to discuss how…

Q: Suppose that we have a sample data for four people and the data has four attributes. The data is…

A: Nominal Attributes are the non numerical attributes. The proximity measure of nominal attributes is…

Q: From the sale records of XYZ Groceries, Mr. Francis wants to find out the most frequent items, and…

A: A set of items is called frequent if it satisfies a minimum threshold value for support and…

Q: e a change, Total = 9 Available Coin Set = { 2, 3, 5 } using dynamic approach

A: NOTE: SINCE THE LANGUAGE OF THE PROGRAM IS NOT MENTIONED, I HAVE USED JAVA FOR THE SOLUTION. Define…

Q: A garderning company is planting trees and flowers at 4 sites on the median of a new road. For each…

A: 1.        total number of sites = 4            so there is 4 places and each place there will a tree…

Q: For all the employees supervised by KING, give them a salary increase, which is equal to the 2% of…

A: This can be done by changing the salary value in all columns where the MGR id is 7839. script in…

Q: For the following data : X (starting hourly wage) = [2, 3, 4, 5, 6] and %3D Y (Number of work…

A: Refer to step 2 for the answer

Q: 1. Are you enrolled in a humanities course? 2. Are you enrolled in a natural science course? 3. Are…

A: As you have posted multiple sub parts , we will solve the first question for you The information…

Q: Problem 4 Select all employee's name and bonus whose bonus is < 1000. Table:Employee | empld | name…

A: GIVEN:

Q: COMPUTE FOR THE FOLLOWING: Gross Pay = no. of hours worked rate per hour (if no. hours is 8 hours or…

A: The program is written in C++. Please find the source code in step 2.

Q: From worksheet Laptop, in cell E18, find the sum of price that has discount. Answer: From worksheet…

A: Answer 1:-  you have not provide the screenshot of the data, but it is ok_ I will give you steps how…

Q: Problem 3: Normalization Consider the following table: STU_NUM STU LNAME STU_MAJOR DEPT_CODE…

A:

Q: Q1. A shop owner has 2 outlets namely a High Street Branch and Mall Branch, before Covid- 19…

A: The answer is given below:-

Q: A pet shop wants to give a discount to its clients if they buy one or more pets and at least five…

A: The answer given as below:

Q: Problem 4 Select all employee's name and bonus whose bonus is « 1000. Table:Employee | empld | name…

A: The query will be given  as I don't have the structure of the table so I am not able to provide the…

Q: If i receive incorrect solution again then be ready to get dislike and reported.

A: Given:

Q: If i receive incorrect solution again then be ready to get dislike and reported

A: Coded using Python.

Q: BU School of Witchcraft and Wizardry is a school of magic that sends admission letters only to…

A: The below images have the Decision Tree as well as the Decision Table for the given problem :

Q: Question 4: - Find the variance for the following data ( 2,4,5,6,8,17 * Your answer 11 17 20 24 32…

A: Here First see what data given and what value will be find, then given step by step solution. I hope…

Q: Using R, use antithetic variables to estimate the following: 3 In(1+x²) dt 0 = x2

A: The handwritten solution along with the snapshots of the R studio is given in the next step:

Q: Four married couples have bought 8 seats in the same row for a concert. In how many different ways…

A: If all the men sit together to the right of all the women- All the men sit together to the right of…