Informatics Practices
Perform the following question based on these tables :
table PAYDAY (contains one column only)
CycleDate DATE
table ADDRESS ( contains following eight columns)
LastName VARCHAR(25),
FirstName VARCHAR(25),
Street VARCHAR(50),
City VARCHAR(25)
State CHAR(2),
Zip NUMBER,
Phone VARCHAR(12),
Ext VARCHAR(5)
Write a query to show the city of user with first name as 'MARK'.
Related Questions
Given the table LIBRARY :
No Title Author Type Pub Qty Price 1 Data Structure Lipschutz DS McGraw 4 217 2 Computer Studies French FND Galgotia 2 75 3 Advanced Pascal Schildt PROG McGraw 4 350 4 Dbase dummies Palmer DBMS PustakM 5 130 5 Mastering C + + Gurewich PROG BPB 3 295 6 Guide Network Freed NET ZPress 3 200 7 Mastering Foxpro Seigal DBMS BPB 2 135 8 DOS guide Norton OS PHI 3 175 9 Basic for Beginners Morton PROG BPB 3 40 10 Mastering Window Cowart OS BPB 1 225 Give the output of following SQL commands on the basis of table Library.
(i) SELECT UPPER(Title) FROM Library WHERE Price < 150 ;
(ii) SELECT CONCAT(Author, Type) FROM Library WHERE Qty < 3 ;
(iii) SELECT MOD(Qty, 4) FROM Library ;
Write a query to show the current date and time.
Show via query how many days remain until Christmas. Round fractional days up using the numeric function ROUND.
Write the SQL queries which will perform the following operations :
(i) To display the year from your Date of Admission which is '2023-05-15'.
(ii) To convert your email id 'ABC@XYZ.com' to lowercase.
(iii) To remove leading spaces from a string 'my country'.
(iv) To display current date.
(v) To display the value of 106.