[Get it solved] What is the possible data type of the column ‘COL1’?...

Check Out Our Work & Get Yours Done

Submit Work

Download Sample

Enroll in the complete course for only $250 USD*

Order Now

Submit work Offers

What is the possible data type of the column ‘COL1’?

computer science

Description

Answer the following questions:

1. What is the possible data type of the column ‘COL1’?

2. What will the output of the following SQL statements be?

a. ‘SELECT COUNT(*) AS ENTRIES FROM TABLE;’

b. ‘SELECT COUNT(COL1) AS ENTRIES FROM TABLE;’

c. ‘SELECT COUNT(DISTINCT COL1) AS ENTRIES FROM TABLE;’

3. Write a query to fetch rows with values ranging from 0 to 2 (assuming the data type to be same as mentioned above)

Question 5: Consider the below table:

ord_no	purch_amt	ord_date	customer_id	salesman_id
70001	150.5	05-10-2012	3005	5002
70009	270.65	10-09-2012	3001	5005
70002	65.26	05-10-2012	3002	5001
70004	110.5	17-08-2012	3009	5003
70007	948.5	10-09-2012	3005	5002
70005	2400.6	27-07-2012	3007	5001
70008	5760	10-09-2012	3002	5001
70010	1983.43	10-10-2012	3004	5006
70003	2480.4	10-10-2012	3009	5003
70012	250.45	27-06-2012	3008	5002
70011	75.29	17-08-2012	3003	5007
70013	3045.6	25-04-2012	3002	5001

1. Find out the number of orders booked and their total purchased amount for each day. The output should be in the below format:

a. "For 2001-10-10 there are 15 orders and total amount is Rs.100"

2. Find the total purchase amount at a customer salesman level and rank the salesmen based on the total sales done

3. Find the orders with all the field in such a manner that, the oldest order date will come first and the highest purchase amount of same day will come first

Question 6: Write a query in SQL to obtain the name of the physicians who are the head of each department. Use the below two tables

Sample table: physician

employee id	name	position	ssn
1	John Dorian	Staff Internist	111111111
2	Elliot Reid	Attending Physician	222222222
3	Christopher Turk	Surgical Attending Physician	333333333
4	Percival Cox	Senior Attending Physician	444444444
5	Bob Kelso	Head Chief of Medicine	555555555
6	Todd Quinlan	Surgical Attending Physician	666666666
7	John Wen	Surgical Attending Physician	777777777
8	Keith Dudemeister	MD Resident	888888888
9	Molly Clock	Attending Psychiatrist	999999999

Sample table: department

department id	name	head_employee_id
1	General Medicine	4
2	Surgery	7
3	Psychiatry	9

Output Table:

department id	dept_name	head_employee_name
Ask This Assignment To Be Done By Our Experts Get instant assignment help service Related Questions in computer science category We discussed user interfaces what are they and for each list some advantages and disadvantages. When considering the purchase of a new system what must be considered? Discuss the ISO’s OSI and relate TCP/IP to it. Explain the term data hiding, which is used in object-oriented programming. Is data hiding a valuable security consideration? Why or why not? Can I get this question Instead the first one Prove an upper bound for the function T defined by the following relations: T(1) = 1, T(n) ≤ 34 · T(n/17) + 17n. To get full points, your answer should be tight up to O(1) factors. C programs related to data conversions should be as described in the document Case Study 2-23 Developing a Coding Quality Plan See attached document for the assignment. Answer in APA format along with a reference page. Write a game of 5 card stud, where you play against the computer. The computer will be the dealer. CS221: C and Systems Programming Fall 2019 - Lab 9.1 (Solved) Assume that you are trying to build an operation interface which allows the mechanical engineering students in UNT to register for any MEEN class (which are highlighted in blue as shown in 2019-2020 MEE curriculum flowchart). Which attribute is used to start a numbered list with a number of your choice? Demonstrate A Basic System Functionality Of The Essential Components For This Assignment. Get Higher Grades Now Tutors Online Enter Your Full Name Please enter your Full Name in order to search your order more easily in our database. Please enter a valid number. Phone Number Is Required Phone Number is required to notify you about the order progress or updations through whatsapp, text message, or sometimes by calling you. We Will Use E-Mail Only For Communication regarding your orders. To send you invoices, and other billing info. To provide you with information of offers and other benefits. Select A Deadline Please select a deadline that is feasible to work on. Sometimes low deadlines lead to low-quality or no work. Hence, please choose a reasonable deadline for everyone to take care of. Description Drop Files Here Or Click to Upload Upload Files Please Upload all instruction files and if possible some relevant material. Please avoid attaching duplicate files . In case of a larger file size(>25MB), please send it through the public drive link. Get Free Quote! 290 Experts Online Policy Payment & Wallet Policy Refund Policy Honor Code Privacy Policy Copyright Policy Terms And Conditions Exploring About Us Submit Question Complete Course Help Service Package Plagiarism Check Questions & Answers Sitemap Other Contact Us FAQ Blog Reviews Word Counter Connect With Us (US) +1 (716) 328-1847 (IN) +91 9710600026 Get Instant Help with your Questions & boost your grades you can count us with it Highly Satisfied Students 4.9/5 Based On 19835+ Reviews Get Help Now We Provide Services Across The Globe Australia UK USA UAE Singapore Canada New Zealand Malaysia India Ireland Germany © Copyright 2012 - 2024 calltutors.com Disclaimer: The reference papers or solutions provided by Calltutors.com serve as model papers or solutions for students or professionals and are not to be submitted as it is to any institutions. These documents are intended to be used for research and reference purposes only. University and company's logo's are the property of respected owners. We don't have affiliation with the mentioned universities. By using our services means, you agree to our Honor Code , Privacy Policy , Terms & Conditions , Payment , Refund & Cancellation Policy.

Enroll in the complete course for only $250 USD*

What is the possible data type of the column ‘COL1’?

computer science

Description

Get instant assignment help service

Related Questions in computer science category

Policy

Exploring

Other

Connect With Us

Get Instant Help with your Questions & boost your grades

you can count us with it Highly Satisfied Students 4.9/5 Based On 19835+ Reviews

We Provide Services Across The Globe

Get Instant Help with your Questions &
boost your grades

you can count us with it
Highly Satisfied Students 4.9/5
Based On 19835+ Reviews