From worksheet Nike, in cell H10, display the number (2016,9,18) in date format. Answer:

Q: Which cards do not have a price recorded. Display all fields in the same column order as defined in…

A: Answer: We have to print table based on data given . here we will use SQL query to print data. we…

Q: create table emp ( eid number(7), fname char(20), lname char(20), salary   number, primary key…

A: Since you have not provided the database name to write the SQL code so I am using MySQL database to…

Q: Create a procedure to add a row to the INVOICES table.

A: I give the code ,output is not shown because table is not given. refer it

Q: Display available Hotels (by ID, Name, and address) in the City of Chicago with a maximum capacity…

A: In this we have to connect 3 tables  hotel, guest, booking by using join

Q: List the student who has highest GPA, but while displaying use any alias name to display the output:

A: MAX function will return the maximum value in a column and we have to display records having maximum…

Q: What is the complete form of the URL?

A: URL is the link address of a resource which can be a file or a webpage on the internet.

Q: after revisiting the last table, what number should replace the value in the intersection of…

A: For intersection values, minimum uncovered value (x=10) should be added. For better understanding…

Q: Display first name, last name and job title of all employees.

A: NOTE - Here I have Oracle SQL to solve the given problem. I have used the Select statement to…

Q: pls answer as soon as possible

A: Ans : The correct term to design the specific algorithm is: d) Flowchart

Q: Choose the correct answer based on the table

A: Given : In the given excel data :

Q: SELECT P.NAME, P. EMAIL FROM PASSENGER P WHERE P.ID NOT IN SELECT PASSENGER_ID FROM RIDE_PASSENGER;

A: SQL is the structured query languages. This is used to store, manipulate and to retrieve the datas…

Q: Show the name of galleries located in Germany with their corresponding paintings titles. * Your…

A: 1. Query: SELECT g.G_Name, p.PaintingTitle FROM Gallery g, Presented p WHERE g.G_location="Germany"

Q: -----SQL---- Show the orderld, the Employee Last Name, the product Name, and show only these number…

A: Hello student Greetings Hope you are doing great. Thank You!!!

Q: The topic is the summary below.

A: Given: Write an essay about the imortance of this topic. State the present situation today that…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: How to detach a photo in my question? or How do I delete the question I asked in Bartleby?

A: In addition to typing your question, you can also attach up to two images (such as a photo or…

Q: List the complete location table (all rows and all columns).

A: Query select * from Location, Explanation:   select clause is used to retrieve data from specified…

Q: From worksheet Product, in cell l13, display today's date and time.

A: Given That From worksheet Product, in cell l13, display today's date and time.

Q: Id Name Address Status 1001 Sheikha Muscat Registered 1001 ITDR3101 FL20 B 1002 Amani Salalah…

A: Here we need to find all students who have registered.  Also find all students who have postponed…

Q: Find the ID and name

A: Consider the table EMPLOYEE : emp_id | emp_fname | emp_lname | emp_gender…

Q: What is the entire URL?

A: URL: The term URL refers to Uniform Resource Locator.  It is the address of a resource on the…

Q: From worksheet Nike, in cell M1, display the year from the date given in the cell L1. Answer:

A: Since the "Sales table" is not shown completely so unable to calculate the second question. Please…

Q: Using the World database, how many regions are in the continent of Antarctica?  Display this number…

A: SQL is the language that is used to communicate with the database. With the help of SQL, data can be…

Q: Create a table showing hat sizes in the United States and Europe.

A: Hat sizes in the United States and Europe

Q: Display the unique RType in the ROOMS table. Sort the RType in descending order.

A: Required: Display the unique RType in the ROOMS table. Sort the RType in descending order.

Q: 1. Display the employee id, their first names and last names joined together, the length of the…

A: As per out guidelines, we are supposed to answer only one question. Kindly repost the remaining…

Q: -Write the data commentary for the graph below. The chart below shows global sales of the top five…

A: In three distinct years, 2009,2011 and 2013, the graph compares mobile phone sales by five different…

Q: Which of the following is false about 1NF? Column should contain values of same type. None are…

A: Each column of your table should be single valued which means they should not contain multiple…

Q: From worksheet Accessories, in cell O5, display the hour from the time given in cell O3.

A: HOUR is the function used to extract the hour from time in 24 hour format It returns the hour value…

Q: A company assigns to each of its employees and ID code that consists of one, two or three uppercase…

A: The question has been answered in step2

Q: 5. List the name and phone number of the customer with area code of '678'.

A: Street is containing the area code. We will use like operator.

Q: From worksheet Product, in cell 15, display the week number of the date given in cell 19. Answer:

A: Given: Calculate week number for excel.

Q: ormalise the table to 3rd Normal Form

A: Given : In the given question , we have provided the table. The task is to perform the 3NF on the…

Q: 4. List all customers (last name, first name and zip code) whose zip code is missing (unknown). 5.…

A: According to the Question below the Complete Query:

Q: Find the name of the organization that has the smallest grant contribution.Using mysql

A: Given: Find the name of the organization that has the smallest grant contribution.Using mysql

Q: According to the image what is the third row of the table? Başlık Başlık Başlık Başlık İçerik 1…

A: According to the table image given what is the third row?

Q: What are the minimum and maximum Read scores?

A: TOEFL tests are only scored by a centralized scoring network, never at the test center. The Reading…

Q: Task 12: When deleting a customer, subtract the balance multiplied by the sales rep’s commission…

A: The command to create a trigger to update the commission of the sales rep table by adding up the…

Q: SQL BITS List client number, balance, consultant number, and consultant last name of every client…

A: SQL query to list number and names of all clients   select ClientNum, ClientName from Client;   SQL…

Q: Find the managers who have given the most amount of money to a single organization. For the 3…

A: We need to display managers who have given the most amount of money to a single organization. For…

Q: In Excel, what does it mean if a cell is filled with hashtags?

A: Introduction: Hashes are algorithms used to extract a fixed-length bit string value from a file. A…

Q: Use the appropriate MySQL command to list all tables in the books database

A: To list the tables in a MySQL database: Log into your database using the MySQL command line client…

Q: For each of the following items, determine whether the data type should be aninteger, string, or…

A: integer data type: This data type stores the numeric value of data. It is useful for storing…

Q: 6. How many different phone numbers are possible in the area code 928?

A: Possible number of phone numbers in each area code.

Q: • Select the FirstName of customers with the highest Total in Invoice.

A: We have to select first-name of customers with the highest total invoice

Q: Normalize the following table into Third Normal Form (3NF). Student Student-ID Post-Code City…

A: Given : Table name = Student Attributes = Student-ID , Name, Age , Post-Code , City

Q: From worksheet Nike, in cell D1, display today's date. Answer:

A: Answer:

Q: False

A: EULER PATH Euler path is a path that visits each edge exactly once. This path starts and ends on…

Q: Display details of employee with ID 150 or 160.

A: We need to write a query to display the details of employees whose ID is 150 or 160. We have a table…