A relation Vehicles is given below : V_no Type Company Price Qty AW125 Wagon Maruti 250000 25 J0083 Jeep Mahindra 4000000 15 -Technology

A relation Vehicles is given below : V_no Type Company Price Qty AW125 Wagon Maruti 250000 25 J0083 Jeep Mahindra 4000000 15 -Technology
by

1 Answer

Answer :

a. select Type, avg(Price) from Vehicle group by Type having Qty>20;b. select Company, count(distinct Type) from Vehicle group by Company;c. Select Type, sum(Price* Qty) from Vehicle group by Type;
by

Related questions

1. Indian companies into foreign collaboration-Maruti – Suzuki, Hero – Honda, Mahindra & Mahindra, Tata – Timken

Description : 1. Indian companies into foreign collaboration-Maruti – Suzuki, Hero – Honda, Mahindra & Mahindra, Tata – Timken

Last Answer : Find the odd word out: 1. Indian companies into foreign collaboration-Maruti - Suzuki, Hero - ... disinvestment take place - Maruti, ONGC, ITDC, VSNL

The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because : (A) Non key attribute V_name is dependent on V_no which is part of composite key (B) Non key attribute V_name is dependent on Qty_sup (C) key attribute Qty_sup is dependent on primary_key unit price (D) key attribute V_ord_no is dependent on primary_key unit price

Description : The Relation Vendor Order (V_no, V_ord_no, V_name, Qty_sup, unit_price) is in 2NF because : (A) Non key attribute V_name is dependent on V_no which is part of composite key (B) ... Qty_sup is dependent on primary_key unit price (D) key attribute V_ord_no is dependent on primary_key unit price

Last Answer : (A) Non key attribute V_name is dependent on V_no which is part of composite key

Mahindra Electric has released ----electric vehicles in the Indian market up to 2020 a. 2 b. 4 c. 6 d. 8

Description : Mahindra Electric has released ----electric vehicles in the Indian market up to 2020 a. 2 b. 4 c. 6 d. 8

Last Answer : Ans:- b.4

For small scale industries the company registration fee is a) Rs.100000 c) Rs.25000 b)Rs.250000 d) Rs.150000

Description : For small scale industries the company registration fee is a) Rs.100000 c) Rs.25000 b)Rs.250000 d) Rs.150000

Last Answer : 25000

Minimum Test Required for Statement Coverage :- Disc = 0 Order-qty = 0 Read Order-qty If Order-qty >=20 then Disc = 0.05 If Order-qty >=100 then Disc =0.1 End if End if a) Statement coverage is 4 b) Statement coverage is 1

Description : Minimum Test Required for Statement Coverage :- Disc = 0 Order-qty = 0 Read Order-qty If Order-qty >=20 then Disc = 0.05 If Order-qty >=100 then Disc =0.1 End if End if a) Statement coverage is 4 b) Statement coverage is 1

Last Answer : b) Statement coverage is 1

Forty percent of Mouli’s annual salary is equal to 160% of Surya’s annual salary. Surya’s monthly salary is 80%of Gowthaman’s monthly salary. If Gowthaman’s annual salary is ` 12 lacs, what is Mouli’s monthly salary ? (At some places annual income and in some place monthly income is given.) a) 180000 b) 1200000 c) 320000 d) 250000

Description : Forty percent of Mouli's annual salary is equal to 160% of Surya's annual salary. Surya's monthly salary is 80%of Gowthaman's monthly salary. If Gowthaman's annual salary is ` 12 lacs, what is Mouli's ... income and in some place monthly income is given.) a) 180000 b) 1200000 c) 320000 d) 250000

Last Answer : Answer: C Gowthaman’s monthly salary = 12,00,000/12  = 1,00,000 Surya’s monthly salary = 1,00,000 x 80/100 = 80,000 Mouli’s monthly salary = 80,000x 1600/40  =3,20,000

Which of the following was declared as “Best Company Promoting Sports (Private sector)” in the country at the National Sports Awards 2015? A) Kotak Mahindra Bank B) Yes Bank C) Axis Bank D) HDFC Bank E) None of these

Description : Which of the following was declared as “Best Company Promoting Sports (Private sector)” in the country at the National Sports Awards 2015? A) Kotak Mahindra Bank B) Yes Bank C) Axis Bank D) HDFC Bank E) None of these

Last Answer : B) Yes Bank Explanation: Lalita Babar was named Sportsperson of the Year in India Sports Awards.

The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Description : The director of a company uses a database to store data about job title. This is a part of the database given below: -Technology

Last Answer : 1. 62. 63. Secretary4. Finance department and their Payroll Numbers are A621 and M502.

Calculate the moment of inertia about the axis parallel to welds and shift it to CG by considering thickness of welds t. a) tɜ+2000t b) None of the listed c) 250000 t d) 125000 t

Description : Calculate the moment of inertia about the axis parallel to welds and shift it to CG by considering thickness of welds t. a) tɜ+2000t b) None of the listed c) 250000 t d) 125000 t

Last Answer : c) 250000 t

Molecular weight of plastics ranges from (A) 5000 to 10000(B) 20000 to 250000 (C) 500 to 5000 (D) 106 to 109

Description : Molecular weight of plastics ranges from (A) 5000 to 10000 (B) 20000 to 250000 (C) 500 to 5000 (D) 106 to 109

Last Answer : (B) 20000 to 250000

For large scale industries the One time registration fee is a) Rs.25000 c) Rs.250000 b) Rs.100000 d) Rs.700000

Description : For large scale industries the One time registration fee is a) Rs.25000 c) Rs.250000 b) Rs.100000 d) Rs.700000

Last Answer : Rs.100000

Maruti

Description : Hello, can't someone send the Maruti installation guide in pdf format? Where are those stray wires around the starter?

Last Answer : Unfortunately, it's not PDF, but only JPG, and it's good to use. The password of the file is - Download link

Maruti

Description : Hello. There is a Maruti 800 car. I don't know what to do anymore to get started. At first only the starter rattled, then we took it apart. He tried to leave afterwards, but just couldn't get it. ... is no engine sound. I want ideas if you have any. I listen to anything. But I will not sell. Thanks

Last Answer : You might want to buy a starter motor from a breaker with bendix. I don’t think it would be expensive, I bought it for Toyota for 15,000. 

Maruti Swift japan model available in India?

Description : Maruti Swift japan model available in India?

Last Answer : Swift is an international model from Suzuki. As I know they have the same model in every countries they exist. Full option models of the car is the same thing only in every markets. The only changes ... quality of body and wheels. Other than that I can't find any difference as a car enthusiast.

X Ltd. purchased a car from Maruti Udyog Ltd. for Rs. 5,00,000. As per agreement Rs. 80,000 was to be paid in cash and the balance by issue of shares of Rs. 10 each at a premium of Rs. 5 per share. How many shares should X Ltd. issue to Maruti Udyog Ltd. for the car ? (A) 30,000 shares (B) 29,000 shares (C) 28,500 shares (D) 28,000 shares

Description : X Ltd. purchased a car from Maruti Udyog Ltd. for Rs. 5,00,000. As per agreement Rs. 80,000 was to be paid in cash and the balance by issue of shares of Rs. 10 each at a premium of Rs. 5 per share. How many ... . for the car ? (A) 30,000 shares (B) 29,000 shares (C) 28,500 shares (D) 28,000 shares

Last Answer : Answer: 28,000 shares

Name the steering gear box used in following: (i) Maruti ‘Alto’ (ii) Tata ‘Sumo’ (iii) Ashok Leyland Truck (iv) Road Roller

Description : Name the steering gear box used in following:  (i) Maruti ‘Alto’  (ii) Tata ‘Sumo’  (iii) Ashok Leyland Truck (iv) Road Roller

Last Answer : (i) Maruti ‘Alto’=========Rack and Pinion Type Gear Box. (ii) Tata ‘Sumo’==========Recireulating Ball Type Gear Box. (iii) Ashok Leyland Truck === Worm and Nut Type Gear Box (iv) Road Roller=========== Worm and Roller Type Steering Gear Box

According to the price/quality strategy matrix, when a company overprices its product in relation to its quality it is considered to be using which type of strategy ? 1. Good-value strategy 2. Premium strategy 3. Overcharging strategy 4. Snob strategy 5. none of these

Description : According to the price/quality strategy matrix, when a company overprices its product in relation to its quality it is considered to be using which type of strategy ? 1. Good-value strategy 2. Premium strategy 3. Overcharging strategy 4. Snob strategy 5. none of these

Last Answer : Overcharging strategy

Which of the following banks has planned to commence urban microfinance operations in its 85 branches across the country? A) Yes Bank B) Kotak Mahindra Bank C) ICICI Bank D) Axis Bank E) None of these

Description : Which of the following banks has planned to commence urban microfinance operations in its 85 branches across the country? A) Yes Bank B) Kotak Mahindra Bank C) ICICI Bank D) Axis Bank E) None of these

Last Answer : D) Axis Bank Explanation: India s third largest private sector lender Axis Bank has forayed into Urban Microfinance segment and will now provide collateral free credit facilities to low- ... s flagship microfinance programme will be delivered via its technology driven ‗TAB based lending solution.

The Headquarters of Kotak Mahindra Bank is located in _______ A. Mumbai B. Hyderabad C. Chennai D. Bangalore

Description : The Headquarters of Kotak Mahindra Bank is located in _______ A. Mumbai B. Hyderabad C. Chennai D. Bangalore

Last Answer : A. Mumbai Explanation: Kotak Mahindra Bank is an Indian private sector banking headquartered in Mumbai, Maharashtra. Kotak Mahindra Bank Launches International Banking Unit in GIFT City recently. Kotak ... the financial world who control the flow of trillions of dollars around the global economy.

Which of the following banks is ready to acquire Microfinance Grama Vidiyal? A) Bandhan Bank B) Yes Bank C) Axis Bank D) Kotak Mahindra Bank E) IDFC Bank

Description : Which of the following banks is ready to acquire Microfinance Grama Vidiyal? A) Bandhan Bank B) Yes Bank C) Axis Bank D) Kotak Mahindra Bank E) IDFC Bank

Last Answer : E) IDFC Bank Explanation: Private sector lender IDFC Bank announced the acquisition of Tamil Nadu-based Grama Vidiyal Microfinance that will help it widen the reach.

Earlier in July, which of the following companies was upgraded to a high safety grade by Crisil? A) Manappuram Finance Limited B) Mahindra Finance C) Muthoot Finance D) Kosamattam E) None of these

Description : Earlier in July, which of the following companies was upgraded to a high safety grade by Crisil? A) Manappuram Finance Limited B) Mahindra Finance C) Muthoot Finance D) Kosamattam E) None of these

Last Answer : C) Muthoot Finance Explanation: Ratings firm Crisil has upgraded Muthoot Finance‘s long-term debt rating to a high safety grade of AA/stable from AA-/stable earlier. Under Crisil scale, AA rating will fall under high safety category and carries very low credit risk.

Kotak Mahindra Bank has enabled which of the following banks online shopping portal on its mobile banking app to provide seamless shopping experience for its customers? A) Flipkart B) Snapdeal C) Amazon India D) Ebay India E) Mytra

Description : Kotak Mahindra Bank has enabled which of the following banks online shopping portal on its mobile banking app to provide seamless shopping experience for its customers? A) Flipkart B) Snapdeal C) Amazon India D) Ebay India E) Mytra

Last Answer : A) Flipkart Explanation: Private sector lender Kotak Mahindra Bank has enabled online shopping portal Flipkart in its mobile banking application in order to ensure a seamless shopping experience for its ... mode. Through this integration the bank will try to solve that problem for our customers.

Which of the following surrendered their “in-principle” to launch payments banks? A. Cholamandalam Distribution Services B. Dilip Shanghvi, Sun Pharmaceuticals C. Tech Mahindra D. All of the Above E. None of the Above

Description : Which of the following surrendered their “in-principle” to launch payments banks? A. Cholamandalam Distribution Services B. Dilip Shanghvi, Sun Pharmaceuticals C. Tech Mahindra D. All of the Above E. None of the Above

Last Answer : D. All of the Above Explanation: Three of the 11 entities have surrendered their licenses. They are ―Chalomandalam Distribution Services‖, ―Dilip Shanghvi, Sun Pharmaceuticals‖ and ―Tech Mahindra‖.

Power operated Paddy transplanter is being manufactured in India by (a) M/s Escorts Ltd. (b) M/s Mitsubishi Ltd (c) M/s Eicher tractors Ltd (d) M/s Mahindra Ltd

Description : Power operated Paddy transplanter is being manufactured in India by (a) M/s Escorts Ltd. (b) M/s Mitsubishi Ltd (c) M/s Eicher tractors Ltd (d) M/s Mahindra Ltd

Last Answer : (b) M/s Mitsubishi Ltd

It is the first tractor manufacturer in India. b. M/s Mahindra Ltd c. M/s John Deer Ltd d. None of the above

Description : It is the first tractor manufacturer in India. b. M/s Mahindra Ltd c. M/s John Deer Ltd d. None of the above

Last Answer :  Ans- a. M/s Eicher Lt

The leading manufacturer of farm equipment or agriculture equipment it in India are a) Mahindra and Mahindra b) Sonalika c) Force d) All of the above

Description : The leading manufacturer of farm equipment or agriculture equipment it in India are a) Mahindra and Mahindra b) Sonalika c) Force d) All of the above

Last Answer : Mahindra and Mahindra

The electric cars available in india are: A . Hyndai Kona Electic B. Mahindra E20 C . Tata tigor EV 2019 D. All of the above

Description : The electric cars available in india are: A . Hyndai Kona Electic B. Mahindra E20 C . Tata tigor EV 2019 D. All of the above

Last Answer : D. All of the above

First mass produced hybrid vehicle internationally is..................... 1) Tesla model X. 2) Mahindra e2o. 3) Toyota Prius. 4) Ford GT.

Description : First mass produced hybrid vehicle internationally is..................... 1) Tesla model X. 2) Mahindra e2o. 3) Toyota Prius. 4) Ford GT.

Last Answer : 3) Toyota Prius.

Identify input/output devices from the clues given below: (a) Transfers typed or handw -Technology

Description : Identify input/output devices from the clues given below: (a) Transfers typed or handw -Technology

Last Answer : (a) Scanner(b) Barcode reader(c) Optical Mark Recognition (OMR)(d) Magnetic Ink Character Recognition (MIGR)(e) Printer (f) Speaker

Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Description : Name the term defined by given below statement: “A group of computers connected to each other by a link.” -Technology

Last Answer : Computer network is defined as a group of computers connected to each other by a link.

Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Description : Answer the following questions based on the database given below: Prod_Id Prod_Name Category -Technology

Last Answer : 1. The primary key of the given table Product will be Prod _Id because no two products have the same Product_Id. So, it will be uniquely identified for each record in the table.2. The suitable data ... = 88. The data type OLE Object is suitable for adding the photograph of the product to the table.

Some features of a specific operating system are given below: 1. Free/Open source -Technology

Description : Some features of a specific operating system are given below: 1. Free/Open source -Technology

Last Answer : (i) Linux(ii) With Linux, you get four desktop screens known as workspace.

Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Description : Write the HTML code to create the exact table which is given below: ADMNO SNAME NAME DOB -Technology

Last Answer : The HTML code is ADMNO SNAMENAMEDOB1110MANJITRANJIT4-MAR-1998

Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized -Technology

Description : Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized -Technology

Last Answer : 1. to specify the title of the Web page.2. contains all the content that is to be displayed on the Web page and all the various formatting and structural tag.3. used to create an unordered ... anchor tag. Use the href attribute to provide the reference of the Web page that you want to hyperlink.

Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized in creating this -Technology

Description : Carefully study the Web page given below. Identify 10 tags (structural as well as formatting tags) that have been utilized in creating this -Technology

Last Answer : 1. to specify title of the Web page.2. contains all the text content that is to be displayed on Web page and all the various formatting and structural tag.3. defines the most important and biggest ... provide caption to the table.9. used to create a table row.10. used to define data cells.

Draw the XML tree for code given below: -Technology

Description : Draw the XML tree for code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: <MOVIES> <ENGLISH> -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below -Technology

Description : Draw the XML tree for the code given below -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : The XML tree is

Draw the XML tree for the code given below: -Technology

Description : Draw the XML tree for the code given below: -Technology

Last Answer : Draw the XML tree

Write the HTML code to generate the following web page with the given below specifications: -Technology

Description : Write the HTML code to generate the following web page with the given below specifications: -Technology

Last Answer : Income Tax Slabs 2017-18INCOME TAX SLABS 2017-18S.No.Income RangeTax%10-250000NIL2250001-50000010%3500001-100000020%4>100000030%Next Page

Dev, a website designer with “Creative Designers Pvt. Ltd.” has written the following code. Observe the code given below -Technology

Description : Dev, a website designer with “Creative Designers Pvt. Ltd.” has written the following code. Observe the code given below -Technology

Last Answer : (i) XML code(ii) Company(iii) name, dept(iv) eid, deptid

With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Description : With reference to the above given tables, write commands in SQL for (i) and (ii) and output for (iii) below: -Technology

Last Answer : (i) select TName, Passenger from Train T, Reservation R where T.TrainId=R.TrainId;(ii) select T.* from Train T, Reservation R where T.TrainId!=R.TrainId;(iii)TrainIdTNameSourceDestination3424Lucknow MailLucknowNew Delhi5400Century ExpressNew DelhiKanpur

Write a code to plot the speed of a passenger train as shown in the figure given below: -Technology

Description : Write a code to plot the speed of a passenger train as shown in the figure given below: -Technology

Last Answer : import matplotlib.pyplot as pltimport numpy as npx = np.arange(1, 5)plt.plot(x, x*1.5, label='Normal')plt.plot(x, x*3.0, label='Fast')plt.plot(x, x/3.0, label='Slow')plt.legend()plt.show()

Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Description : Write a python code to create a data frame with appropriate headings from the list given below : -Technology

Last Answer : import pandas as pd# initialize list of listsdata = [['S101', 'Amy', 70], ['S102', 'Bandhi', 69], ['S104','Cathy', 75], ['S105', 'Gundaho', 82]]# Create the pandas DataFramdf = pd.DataFrame(data, columns = ['ID', 'Name', 'Marks'])# printdataframe. print(df )

Write a small python codeto create a dataframewith headings(a and b) from the list given below : [[1,2],[3,4],[5,6],[7,8]] -Technology

Description : Write a small python codeto create a dataframewith headings(a and b) from the list given below : [[1,2],[3,4],[5,6],[7,8]] -Technology

Last Answer : import pandas as pddf = pd.DataFrame([[1, 2], [3, 4]], columns = ['a','b'])df2 = pd.DataFrame([[5, 6], [7, 8]], columns = ['a','b'])df = df.append(df2)

Consider the following dataframe, and answer the questions given below: -Technology

Description : Consider the following dataframe, and answer the questions given below: -Technology

Last Answer : (i) print(df.mean(axis = 1, skipna = True)) print(df.mean(axis = 0, skipna = True))(ii) print(df.sum(axis = 1, skipna = True))(iii) print(df.median())

Write the code given below using ‘for’ loop instead of ‘while’ loop : -Technology

Description : Write the code given below using ‘for’ loop instead of ‘while’ loop : -Technology

Last Answer : The given code using ‘for’ loop instead of ‘while’ loop :int ifor (i = 1 ; i < = 5 ; i + +){if (1 * i = = 4)jTextFieldl. setText ( “ “ + i) ;}

Consider the table ‘Teacher’ given below. -Technology

Description : Consider the table ‘Teacher’ given below. -Technology

Last Answer : (i) Select count(Department) from Teacher ;(ii) Select count (*) from Teacher ;

Consider the tables given below. Salesperson -Technology

Description : Consider the tables given below. Salesperson -Technology

Last Answer : (i) Primary, Foreign(ii) Salespersons cannot be set as the primary key in the table Orders because table Orders has already primary key and one table cannot have more than one primary key column.