5. Consider the following table named …

5. Consider the following table named "GARMENT". Write command of SQL for (i) to (iv). PRICE 1400.00 1600.00 1100.00 4000.00 1500.00 1200.00 Pink Brown Blue L L GCODEMA (i) To display names of those garments that are available in 'XL' size. Table: GARMENT SIZE Red Blue Black XL XL L M&E GNAME TShirt HD Jeans Skirt Ladies Jacket Trousers Ladies Top COLOUR To display codes and names of those garments that have their names starting with Ladies'. (iii) To display garment names, codes and prices of those garments that have price in the range 1000.00 to 1500.00 (both 1000.00 and 1500.00 included). (iv) To change the colour of garment with code as 116 to "Orange". 111 112 113 114 115 116 (ii)

What are called tokens

Write a program in python to accept a number and check whether the number is divisible by 3 as well as 5 otherwise decide : (a) Is the number divisible by 3 and not by 5 (b) is the number divisible by 5 and not by 3 (c) is the number neither divisible by 3 or by 5

Write a python program to count three letter words in a given file

Your school has a document enlisting names of school students who have pass this year and taken admission in further courses. You have to edit the documents with the following changes: a) Find the word ‘utilitarian‘ and replace it with the word ‘pragmatic’ (Take care not to replace the word utilitarianism). b) The word college as it occurs in the text should be capitalize. Replace the word college with the correct capitalization i.e with College throughout the text using the appropriate option.

1.1. In a table in MYSQL database, an attribute A of datatype varchar(20) Nes the value "Keshar The attribute S of datatype char(20) has value "Meenakshi". How many characters are occupied by attribute A and attribute 67 a. 20,6 6.6,20 ८. 9,6 d. 6,9

Write a python program to count threwords in a given file

A Railway company uses machines to sell tickets. The machine details and daily sales information are recorded in two tables: Table Name: Machine Table Name: Sales The primary key of the table Machine is Machine_ID. Records in the table Sales are uniquely identified by the fields Machine_ID and Date. (a) Create the tables Machine and Sales. (b) Write a query to find the number of ticket machines in each station. (c) Write a query to find the total ticket income of the station “New Delhi” of each day. (d) Write a query to find the total number of tickets sold by the machine (Machine_ID = 122) till date.

Which book do you all follow for cs? How many chapters are there in the syllabus

What is mean by buffering in file handling?

Differentiate between function and argument