(i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology

(i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology
by

1 Answer

Answer :

mysql> Select Name,SalesAmt from Store order by noOfEmp;mysql> Select city, sum(SalesAmt) from store group by City;mysql> Select count(*),City from store group by City having count(*)>2;mysql> Select Min(DateOpen) from Store;Min(DateOpen)2015-02-06mysql> Select Count(StoreId), NoOfEmp from Store group byNoOfemp having max(SalesAmt)<60000;Count(StoreId)NoOfEmp1101111517
by

Related questions

1. To display Names of Patients, TESTID and Test names for those Patients who were admitted -Technology

Description : 1. To display Names of Patients, TESTID and Test names for those Patients who were admitted -Technology

Last Answer : SQL commands for the given statements :(i) SELECT NAME, TESTID, TESTNAME FROM PATIENT, TESTWHERE PATIENT. TESTID = TEST. TESTID AND DTADMIT BETWEEN 01-DEC-2017' AND '15-DEC-2017' ;(ii) SELECT NAME, TESTNAME, COST ... NAME LIKE '% Sharma %' ;(iii) UPDATE TEST SET COST = COST +50 WHERE COST < 200 ;

Write a query to display customer’s name along with their transaction details. -Technology

Description : Write a query to display customer’s name along with their transaction details. -Technology

Last Answer : Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;

To display the details of all those students who have IP as their optional subject. -Technology

Description : To display the details of all those students who have IP as their optional subject. -Technology

Last Answer : (i) select * from student where optional=‟IP‟;(ii) select name, stream, optional from student where name like 'A%';(iii) update student set average=average+3 where stream=‟Humanities‟ and optional='Maths';(iv) select name from student where average>75;

Can you get anywhere in fashion design in Omaha, NE?

Description : Can you get anywhere in fashion design in Omaha, NE?

Last Answer : 1323 N 108th St, Omaha - +1 402-496-2909 this information we helps you geting the details of the fashion design in Omaha

……….. helps us to learn anywhere using Internet. -Technology

Description : ……….. helps us to learn anywhere using Internet. -Technology

Last Answer : E-learninghelps us to learn anywhere using the Internet.

What stores offer the most up to date fashion apparel?

Description : What stores offer the most up to date fashion apparel?

Last Answer : I suggest having a look in the store "new look". New look provide the newest fashions and clothes that are available to the consumer market. There are ome excellent deals. Also look in harrods if you are in England.

At big gas stations with convenience stores, is the rule "no smoking anywhere on premises" or "no smoking by the pumps?"?

Description : At big gas stations with convenience stores, is the rule "no smoking anywhere on premises" or "no smoking by the pumps?"?

Last Answer : I believe it applies to the entire premises.

Touch screen is an electronic ……….. display that can detect the presence and location of a touch within the display area. -Technology

Description : Touch screen is an electronic ……….. display that can detect the presence and location of a touch within the display area. -Technology

Last Answer : Touch screen is an electronic visual display that can detect the presence and location of a touch within the display area.

Write the HTML code to display horizontal line of red color. -Technology

Description : Write the HTML code to display horizontal line of red color. -Technology

Last Answer :

How would you display text in the title bar of a browser? -Technology

Description : How would you display text in the title bar of a browser? -Technology

Last Answer : To display text in a title bar of a browser, use the tag inside the tag in the HTML document.e.g. HTML document

Write HTML code to display various bullet types. -Technology

Description : Write HTML code to display various bullet types. -Technology

Last Answer : LotusRoseSunHoonoutput

Write HTML code to display ordered lists. -Technology

Description : Write HTML code to display ordered lists. -Technology

Last Answer : Many Ordered ListNumbered listSunMoonLetters 1is t SunMoonLowercase letters starting from 3rd 1etter

Tags and text that do not display directly on the page afe placed in (a) body (b) table -Technology

Description : Tags and text that do not display directly on the page afe placed in (a) body (b) table -Technology

Last Answer : (c) Information in tag is not displayed directly in the Web page. It is used to identify the matter (tags) used in a Web page.

To display the text in italics, ………. tag is used and to display in type writer font, ……… tag is used. -Technology

Description : To display the text in italics, ………. tag is used and to display in type writer font, ……… tag is used. -Technology

Last Answer : To display the text in italics,tag is used and to display in typewriterfont, tag is used.

If you want to display uppercase alphabets instead of numbers, ………… ordered type should you use. -Technology

Description : If you want to display uppercase alphabets instead of numbers, ………… ordered type should you use. -Technology

Last Answer : If you want to display uppercase alphabets instead of numbers, Aordered type should you use.

background attribute is used to display image. -Technology

Description : background attribute is used to display image. -Technology

Last Answer : True It is an attribute of tag used to display the background image.

Write the HTML command to display the following in your Web page. -Technology

Description : Write the HTML command to display the following in your Web page. -Technology

Last Answer : The HTML command is – A2 + B2

Write the HTML code to display an image on the right side of the page. -Technology

Description : Write the HTML code to display an image on the right side of the page. -Technology

Last Answer :

Write the HTML code to display an inline image named pencil.jpg located at C:\ in the center of your Web page. -Technology

Description : Write the HTML code to display an inline image named pencil.jpg located at C:\ in the center of your Web page. -Technology

Last Answer :

Web browsers display images in the following format (a) XBM (b) JPEG -Technology

Description : Web browsers display images in the following format (a) XBM (b) JPEG -Technology

Last Answer : (d) All of these

To display (X+Y)2, correct HTML code is (a) <sub>(X+Y)2</sub> -Technology

Description : To display (X+Y)2, correct HTML code is (a) (X+Y)2 -Technology

Last Answer : (c) (X+Y) 2 code is correct because superscript have to be placed in between and tags.

Which attribute lets you control the display of select border sides of a table? -Technology

Description : Which attribute lets you control the display of select border sides of a table? -Technology

Last Answer : frame attribute displays the selected border sides of the table.

Write HTML code to display a table with border of 5px. -Technology

Description : Write HTML code to display a table with border of 5px. -Technology

Last Answer : l2 „

………….. is the background image of display screen on which windows, icons and other graphical items appear. -Technology

Description : ………….. is the background image of display screen on which windows, icons and other graphical items appear. -Technology

Last Answer : Desktopis the background image of display screen on which windows, icons and other graphical items appear.

The……………. attribute is used to display a specific portion of a table border. -Technology

Description : The……………. attribute is used to display a specific portion of a table border. -Technology

Last Answer : The frameattribute is used to display a specific portion of a table border.

In the rules attribute, the………… value helps to display a table border only between rows. -Technology

Description : In the rules attribute, the………… value helps to display a table border only between rows. -Technology

Last Answer : In the rules attribute, the rows value helps to display a table border only between rows.

The cols value in the rules attribute, allows you to display table border only between columns. -Technology

Description : The cols value in the rules attribute, allows you to display table border only between columns. -Technology

Last Answer : True The cols value in the rules attribute is drawn between columns only.

……….. option is used to display a document before printing. -Technology

Description : ……….. option is used to display a document before printing. -Technology

Last Answer : Print Previewoption is used to display a document before printing.

XML was not designed to (a) display Web pages -Technology

Description : XML was not designed to (a) display Web pages -Technology

Last Answer : (a) XML was designed to store and carry data, not to display Web pages.

I want to see the tracked changes in my document. How do I turn On the display of tracked changes? -Technology

Description : I want to see the tracked changes in my document. How do I turn On the display of tracked changes? -Technology

Last Answer : In MS-Word 2007, on the Review tab, use the little menus in the Tracking group. Final Showing Markup or Original Showing Markup will show what changes you have made. But check the selected items on the Show Markup menu to be sure that Word is showing you the right things.

……….. is used to describe data and ……….. is used to display data. -Technology

Description : ……….. is used to describe data and ……….. is used to display data. -Technology

Last Answer : XML is used to describe data and HTMLis used to display data.

What is the shortcut key to display the Microsoft PowerPoint shortcut menu? -Technology

Description : What is the shortcut key to display the Microsoft PowerPoint shortcut menu? -Technology

Last Answer : (c) Shift + F10 is the shortcut key to display the PowerPoint shortcut menu

If cell range A1 : A5 contain the numbers 20, 16, 5, 35 and 7 then = AVERAGE(A1 : A5, 50) will display. -Technology

Description : If cell range A1 : A5 contain the numbers 20, 16, 5, 35 and 7 then = AVERAGE(A1 : A5, 50) will display. -Technology

Last Answer : The correct answer is(a) 22.167

If you type =2 * (6_4) in cell Al, what value will be display? -Technology

Description : If you type =2 * (6_4) in cell Al, what value will be display? -Technology

Last Answer : (b) = 2*(6-4) = 2*(2) = 4

If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Description : If you enter 15 + 30 in a cell, Excel will display …………….. -Technology

Last Answer : If you enter 15 + 30 in a cell, Excel will display15 + 30.

Write the HTML code to display links of a web page in yellow colour. -Technology

Description : Write the HTML code to display links of a web page in yellow colour. -Technology

Last Answer :

Write HTML code to display the following table : -Technology

Description : Write HTML code to display the following table : -Technology

Last Answer : scheduleDuty Chart8 AM10AM12 AM KEVIN KHUSHBOO AMARJEET

In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Description : In a Bank’s database, there are two tables ‘Customer’ and ‘Transaction’ as shown below. Write a query to display customer’s name who has -Technology

Last Answer : (i) Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';(ii)Select cust_name, t.* from customer c, transaction t where c.Acc_No=t.Acc_No;(iii) ... total amount of all type of transactions, it will only display the total of credit transactions only.

Write a query to display customer’s name who has withdrawn the money. -Technology

Description : Write a query to display customer’s name who has withdrawn the money. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No=t.Acc_No and Transaction_Type= 'Debit';

Write a query to display customer’s name who have not done any transaction yet. -Technology

Description : Write a query to display customer’s name who have not done any transaction yet. -Technology

Last Answer : Select cust_name from customer c,transaction t where c.Acc_No!=t.Acc_No;

While working in Netbeans, Ms. Sonia has designed a login page where she wants to display -Technology

Description : While working in Netbeans, Ms. Sonia has designed a login page where she wants to display -Technology

Last Answer : If statement is more appropriate for this situation because here is given only two conditions which will be executed by if statement while switch statement is used where multiple branch selection statements are given.

Deepti works as a programmer in a travel company. She has developed the following code to display -Technology

Description : Deepti works as a programmer in a travel company. She has developed the following code to display -Technology

Last Answer : switch (choice){Case 1 : JTextFieldl. setText ('New Delhi to Goa') ;break ;Case 2 : jTextFieldl.setText ('New Delhi to Paris') ;break ;Case 3 : jTextFieldl.setText ('New Delhi to Bangkok') ;break ;default: jTextFieldl.setText ('P1. choose valid option') ;}

Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Description : Given a Pandas series called Sequences, the command which will display the first 4 rows is .... (a) print(Sequences.head(4)) -Technology

Last Answer : (a) print(Sequences.head(4))

Write the SQL command that will display the current time and date. -Technology

Description : Write the SQL command that will display the current time and date. -Technology

Last Answer : Select now();

Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Description : Consider the following Series object, S_amt Table 350 Chair 200 Sofa 800 Stool 150 i. Write the command which will display the name -Technology

Last Answer : i. print(S_amt[S_amt>250])ii. S_amt.name= 'Furniture'

Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Description : Consider the following SQL string: “Preoccupied” Write commands to display: (a)“occupied” (b)“cup” -Technology

Last Answer : commands to display:(a)“occupied” (b)“cup”

Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Description : Considering the same string “Preoccupied” Write SQL commands to display: (a) the position of the substring ‘cup’ in the string “Preoccupied” -Technology

Last Answer : (a)select instr 'Preoccupied' , ‘ 'cup'));(b)select left 'Preoccupied',4);

Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Description : Write the SQL functions which will perform the following operations: (i) To display the name of the month of the current date . -Technology

Last Answer : (i) monthname(date(now()))(ii) trim(“ Panaroma “)(iii) dayname(date(dob))(iv) instr(name, fname)(v) mod(n1,n2)

Reema works as a shift technician in Mehta Textiles Ltd. whereas Shirin works as a sales executive in Kashvi Fashion Showroom. -SST 10th

Description : Reema works as a shift technician in Mehta Textiles Ltd. whereas Shirin works as a sales executive in Kashvi Fashion Showroom. -SST 10th

Last Answer : Reema works in the Secondary or Manufacturing Sector. The role of the secondary sector is as follows - 1. The secondary sector covers activities in which natural products undergo changes through ... in this economic system and they tend to work closely, being interdependent of each other.

Is there a friend's stove sales center in Sherpur or Gazipur can be found anywhere

Description : Is there a friend's stove sales center in Sherpur or Gazipur can be found anywhere

Last Answer : You can find friend stove sales center in Gazipur.