ADS Assignment-2 KV22E

Write and execute XML statements for the following two queries: Q1. Find the name of an employee who lives in Lincoln and works in Omaha. Q2. Find salaries of employees who live in the same cities as the companies for which they work.

11. List the isbn of the book, the id and firstname of the editors. Include all books in the bookeditor table.

LAB - Select horses with logical operators The Horse table has the following columns: • ID integer, primary key • RegisteredName - variable-length string • Breed - variable-length string • Height-decimal number • BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.

Transcribed Image Text In this Assignment you need to desgin a Simple Inline query to fetch all the child reocrds using the SOQL Inline query feture. In this Problem you need to Fetch all the Contact and Opportunity reocrds below a Account. You can use specific Account Id to filter or you can use directly but you have write proper query with necessary Field. Please solve the problem and also run the SOQL Query on the Query Editor and attach the output SOLVE In the Salesforce

CREATE OR REPLACE PROCEDURE PROCUNO ( W_ID IN NUMBER ) W_FLAG W TAX W MSG NUMBER : = 0 ; NUMBER : = 0 ; NUMBER : = 0 ; STRING ( 20 ) : = " ; BEGIN SELECT COUNT ( * ) INTO W_FLAG FROM COMPRA WHERE COMPRA_ID - W_ID ; W_TAX : - W_X * 0.115 ; IF W_FLAG = 1 THEN SELECT SUM ( CANTIDADCOMPRADA * PRECIO ) INTO W_X FROM PRODUCTO_COMPRADO WHERE PRODUCTO COMPRADO.COMPRA_ID = W_ID ; UPDATE COMPRA SET COMPRA_X = W_X , ELSE WHERE COMPRA_ID = W_ID ; W_MSG : = ' mensajel " ; END IF ; COMPRA_TAX = W_TAX , COMPRA_TOTAL = W_X + W_TAX W_MSG : = ' mensaje2 ' ; END ;

Q = insert 5 records into your Courses_xxxx table The fid, rid, aid should not be all the same among the 5 records. The enrollment number should be less than the room size.   mysql> select * from Hotel; +---------+---------------+--------+ | hotelno | hotelname     | city   | +---------+---------------+--------+ | ch01    | Omni Shoreham | London | | ch02    | Phoenix Park  | London | | dc01    | Latham        | Berlin | | fb01    | Grosvenor     | London | | fb02    | Watergate     | Paris  | +---------+---------------+--------+ 5 rows in set (0.00 sec)   mysql> select * from Room; +--------+---------+--------+-------+ | roomno | hotelno | type   | price | +--------+---------+--------+-------+ |    501 | fb01    | single | 19.00 | |    601 | fb01    | double | 29.00 | |    701 | ch02    | single | 10.00 | |    701 | fb01    | family | 39.00 | |    801 | ch02    | double | 15.00 | |    901 | dc01    | single | 18.00 | |   1001 | ch01    | single | 29.99 | |   1001 | dc01    |…

Customers CustomerID INT ◆ FirstName VARCHAR(50) ◆ LastName VARCHAR(50) H > Email VARCHAR(100) > Address TEXT Indexes F | Orders OrderID INT > CustomerID INT > OrderDate DATE ◆ TotalAmount DECIMAL (10,2) Indexes # ShippingInformation ShippingID INT > OrderID INT → ShippingAddress TEXT ShippingDate DATE -K > EstimatedArrivalDate DATE → ShipmentStatus VARCHAR(50) Indexes Reviews ReviewID INT > ProductID INT > CustomerID INT ◆ Rating INT Comment TEXT > DatePosted DATE Indexes OrderDetails OrderDetailID INT ▶I > OrderID INT HI-KO ProductID INT → Quantity INT Subtotal DECIMAL (10,2) Indexes T Categories CategoryID INT ◆ CategoryName VARCHAR(255) Indexes Products ProductID INT -H ProductName VARCHAR(255) > Description TEXT ◆ Price DECIMAL (10,2) -I+ CategoryID INT > DiscountID INT Indexes Discounts DiscountID INT ◆ Discount Code VARCHAR(50) ◆ Discount Percentage DECIMAL (5,2) > StartDate DATE > EndDate DATE Indexes For the design above, Write in SQL a query to print customer names who made…

insert 5 records into your Courses_xxxx table The fid, rid, aid should not be all the same among the 5 records. The enrollment number should be less than the room size. mysql> select * from Hotel; +---------+---------------+--------+ | hotelno | hotelname     | city   | +---------+---------------+--------+ | ch01    | Omni Shoreham | London | | ch02    | Phoenix Park  | London | | dc01    | Latham        | Berlin | | fb01    | Grosvenor     | London | | fb02    | Watergate     | Paris  | +---------+---------------+--------+   mysql> select * from Room; +--------+---------+--------+-------+ | roomno | hotelno | type   | price | +--------+---------+--------+-------+ |    501 | fb01    | single | 19.00 | |    601 | fb01    | double | 29.00 | |    701 | ch02    | single | 10.00 | |    701 | fb01    | family | 39.00 | |    801 | ch02    | double | 15.00 | |    901 | dc01    | single | 18.00 | |   1001 | ch01    | single | 29.99 | |   1001 | dc01    | double | 30.00 | |   1001 | fb02…

complete the docstring using the information provided:

Apply the First Normal Form (1NF) and Second Normal Form (2NF) steps to the following two tables.    ST_ID ST_Name ST_Major St_Phone ST_Email 100 Marla jen ACCT (703) 111-2222 mjen@gmail.com 110 Jan Bok MGMT (703) 222-3333 jbok@verizon.net 115 Lee Chan MIS (703) 333-4444 (703) 444-5555 lchan@cox.net Table 1   ID Name Courses 1 Ashely Key MIS 302, MIS 303 2 Katy Pery MIS 310 3 Mickey Zen MIS 303, MIS 350 Table 2

Display employee first name and the position of the second ‘a’ character in the first name if exist, otherwise display a message: Not contains two a Display the employee’s name whose salary is within a range that is specified by the user input as follows: Display the JOB_ID and the position of the character S in the JOB_ID on jobs table as the following: Search of the character S in the JOB_TITLE Result S not found in the name Not Found S in the last character of the name Last Character The name contains the character S Contains S S in the first character of the name First Character

12. List the isbn and name of the book, the id and firstname of the editors. Make sure to include all books in the book table. Order alphabetically by book name.

What are the urlopen and urlretrieve functions?

The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be ≥ 10.0 and ≤ 20.0 BirthDate - date, must be ≥ Jan 1, 2015 Make the following updates: Change the height to 15.6 for horse with ID 2. Change the registered name to Lady Luck and birth date to May 1, 2015 for horse with ID 4. Change every horse breed to NULL for horses born on or after December 22, 2016.

The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be ≥ 10.0 and ≤ 20.0 BirthDate - date, must be ≥ Jan 1, 2015

Python please starter code: # Web App to Get Stock Market Data from AlphaVantage Serviceimport requests#Function that gets stock info from API# Returns results in list of two strings# DO NOT EDIT THIS FUNCTION EXCEPT TO INSERT YOUR API KEY WHERE INDICATEDdef getStock(symbol):baseURL = "https://www.alphavantage.co/query?function=GLOBAL_QUOTE&datatype=csv"keyPart = "&apikey=" + "REPLACE WITH YOUR API KEY" #Add API keysymbolPart = "&symbol=" + symbolstockResponse = requests.get(baseURL+keyPart+symbolPart)return stockResponse.text #Return only text part of response#Function that computes and displays resultsdef main():# Add code that meets the program specifications (see instructions in Canvas)#Code that starts the appmain()

SetID int Job Code int Eff Date date Sal End Date Salary setID Sal Plan varchar(10) Grade Step Biweekly Rate Union Code Extended Step Pay Type 1. a. b. C. d. e. f. g. h. i. date int varchar(10) varchar(10) decimal(8,2) varchar(10) varchar(10) Write a MySQL query to find the distinct values for the extended step. Write a MySQL query to find the minimum bi-weekly rate of pay excluding $0.00, Write a MySQL query to find the maximum biweekly rate of pay for the biweekly rate in the range between $2000 and $4000 inclusive. Write a MySQL query to find the pay type for all the job codes that start with '03' order by the pay type and descending order? Write a MySQL query to find the Effective Date (eff Date) and Salary End Date (sal end date) for grade Q90HO? Write a MySQL query to display the Step and Job Codes in the range from 0110 to 0400. Write a MySQL query to list job code and the range between the highest Biweekly Rate and the lowest Biweekly Rate for the grade that contains NULL?…

Disease Covid-19 has symptoms, a unique id, and covid_19_status e.g.  Symptomatic or Asyptomatic.Covid-19 can infect patients. A patients could have a patient-id, name, sneezing, coughing and fever and It has a method of checkPatient takes values of sneezing coughing and fever and display the result whether the patient is covid +ve or –ve according to the input values given by the user.   Identity the classes (Attributes, function) in the above scenario? Can you code these classes and display the result If the input if 1 for all symptoms then display on console that patient is covid positive. Otherwise display a message it is covid negative?

MySQL Create the DISPLAY_PROPERTY_OWNER procedure which obtains the office location number, address, owner number, owner first name, and owner last name for the property whose property ID is currently stored in I_PROPERTY_ID (provided as a parameter). Place these values in the variables I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME, respectively. Output the contents of I_LOCATION_NUM, I_ADDRESS, I_OWNER_NUM, I_FIRST_NAME, and I_LAST_NAME

Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered From To Price per Roll 1 30 $215 31 60 $195 61 ཙཙ 120 $175 121 and up $155 Click on the datafile logo to reference the data. (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. $ (b) Use the COUNTIF function to determine the number of orders in each price bin. From To Price per Roll Number of Orders 1 30 $215 31 60 $195 61 120 $175 121 and up $155 172 12

Please Convert to 3rd Normal Form

Sp8.

Refer to Question 4 for Database Details Q4-B: Write the required PHP statements to display all users orders in an HTML Table as follows: Username Order Date Time Number of Items Total Qty|Order Status falqaed 2021-11-04 00:00:00 4 4 Order Placed noor 2021-11-04 00:00:00 2 Order Placed Note that Number of Items is the number of different products in one order, while Total Qty is the sum of all quantities inside one order. Tip: use SQL Group By and built-in functions like count and sum Use the editor to format your answer

With the following table:   PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY)   Write the mySQL statement that will insert the following PRODUCT into the table:       PRODUCT_NUMBER: ‘67832’     DESCRIPTION: ‘KRAZY CAT CEREAL’     PURCHASE_DATE: 2023-11-14     CATEGORY: ‘CPG’   Write the mySQL statement that will insert that product but without a description.

SQL: Create a SQL query that uses an uncorrelated subquery and no joins to display the descriptions for products provided by a vendor in area code 615. Remember, the main difference between a correlated subquery and uncorrelated subquery is that, in a correlated subquery, the inner query is dependent upon the outer query, while, with an uncorrelated query, the inner query does not depend upon the outer query. Instead, it runs just once. You should NOT use union, minus, or intersect in this query. The outer query will use the PRODUCT table and the inner query will use the VENDOR table [hint: you should have 9 records of output].   My code: select p_descript from product where (select v_areacode from vendor where v_areacode = '615' ; I am getting this error, problem is I can't see what is missing any assistance is appreciated.  ORA-00936: missing expression

nycflights13::flights Q4<- flights %>%filter(carrier == "JFK") %>%summarise(average_dist = mean(distance)%>%summarise(max_dist = max(average_dist))%>%group_by(Q4, month, day)%>%head(Q4[order(dat$month),(dat$day),(dat$max_dist)],n=5) *not pictured, I did upload, tidy verse, dplyr, and the nycflights13 libraries. Error: Incomplete expression: Q4<- flights %>% filter(carrier == "JFK") %>% summarise(average_dist = mean(distance)%>% summarise(max_dist = max(average_dist))%>% group_by(Q4, month, day)%>% head(Q4[order(dat$month),(dat$day),(dat$max_dist)],n=5) RStudio Question: I can't figure out what is wrong with my code. Could someone take a look at it? See below for what I am trying to do, my code and my error output. I am trying to find what 5 days of the year had the highest mean distance from JFK airport, using the nycflights13 library. I want to format it in month, day, andvmean distance.

In java create an application to manage your data base information the database is already created in mysql tables, the tables are fill, So the user can use your database application user friendly Retrieve all data: Given a table name, retrieve all data from the table and present it to the user. Average: Given a table name and a column name, return the average of the column. Here the assumption is that the column type will be numeric (e.g., cost column). Insert: Given a table name, your program should show the column names of that table and ask the users to input new data to the table. In case of errors, your program should directly show the MySQL errors to the users. Assumption 1: Users will enter data according to the database constraints. Assumption 2: Users will input one record at a time. Delete: Given a table name, your program should show the column names of that table and ask the users to input data that they want to delete. Assumption 1: Users will enter data according to the…

Json document: P = { "p": [ { "logType": “PDF, "accountId": “xxxx” }, { "logType": “PDF”, "accountId": “xxxx” }, { "logType": “PDF”, "accountId": “xxxx” }, { "logType": “PDF”, "accountId": “xxxx” }, { "logType": “PDF”, "accountId": “xxxx” } ] } Then, I want to count the total of logType and accountId like this in python { "logType": 5, "accountId": 5 }

DATA: myBytes BYTE 10h,20h,30h,40hmyWords WORD 8Ah,3Bh,72h,44h,66hmyDoubles DWORD 1,2,3,4,5myPointer DWORD myDoubles QUESTION: mov edx,myDoubles[edi] ; EDX = ?