IP Address Management with Python
Uploaded by
moammedIP Address Management with Python
Uploaded by
moammed<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns:m="[Link]
xmlns="[Link]
<head>
<meta http-equiv=Content-Type content="text/html; charset=unicode">
<meta name=ProgId content=[Link]>
<meta name=Generator content="Microsoft Word 15">
<meta name=Originator content="Microsoft Word 15">
<link rel=File-List href="IP%20with%20Python%20(10)_files/[Link]">
<link rel=Edit-Time-Data href="IP%20with%20Python%20(10)_files/[Link]">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title>Test Generator</title>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>Windows User</o:Author>
<o:Template>Normal</o:Template>
<o:LastAuthor>Windows User</o:LastAuthor>
<o:Revision>7</o:Revision>
<o:TotalTime>13</o:TotalTime>
<o:Created>2025-02-13T05:00:00Z</o:Created>
<o:LastSaved>2025-02-13T05:18:00Z</o:LastSaved>
<o:Pages>6</o:Pages>
<o:Words>1085</o:Words>
<o:Characters>6185</o:Characters>
<o:Lines>51</o:Lines>
<o:Paragraphs>14</o:Paragraphs>
<o:CharactersWithSpaces>7256</o:CharactersWithSpaces>
<o:Version>16.00</o:Version>
</o:DocumentProperties>
<o:OfficeDocumentSettings>
<o:AllowPNG/>
</o:OfficeDocumentSettings>
</xml><![endif]-->
<link rel=themeData href="IP%20with%20Python%20(10)_files/[Link]">
<link rel=colorSchemeMapping
href="IP%20with%20Python%20(10)_files/[Link]">
<!--[if gte mso 9]><xml>
<w:WordDocument>
<w:View>Print</w:View>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:TrackMoves>false</w:TrackMoves>
<w:TrackFormatting/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-IN</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SplitPgBreakAndParaMark/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val="Cambria Math"/>
<m:brkBin m:val="before"/>
<m:brkBinSub m:val="--"/>
<m:smallFrac m:val="off"/>
<m:dispDef/>
<m:lMargin m:val="0"/>
<m:rMargin m:val="0"/>
<m:defJc m:val="centerGroup"/>
<m:wrapIndent m:val="1440"/>
<m:intLim m:val="subSup"/>
<m:naryLim m:val="undOvr"/>
</m:mathPr></w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="false"
DefSemiHidden="false" DefQFormat="false" DefPriority="99"
LatentStyleCount="371">
<w:LsdException Locked="false" Priority="0" QFormat="true" Name="Normal"/>
<w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 1"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 2"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 3"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 4"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 5"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 6"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 7"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 8"/>
<w:LsdException Locked="false" Priority="9" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="heading 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index 9"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 1"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 2"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 3"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 4"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 5"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 6"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 7"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 8"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" Name="toc 9"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="header"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footer"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="index heading"/>
<w:LsdException Locked="false" Priority="35" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="caption"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of figures"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="envelope return"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="footnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="line number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="page number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote reference"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="endnote text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="table of authorities"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="macro"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="toa heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Bullet 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Number 5"/>
<w:LsdException Locked="false" Priority="10" QFormat="true" Name="Title"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Closing"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Signature"/>
<w:LsdException Locked="false" Priority="1" SemiHidden="true"
UnhideWhenUsed="true" Name="Default Paragraph Font"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="List Continue 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Message Header"/>
<w:LsdException Locked="false" Priority="11" QFormat="true" Name="Subtitle"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Salutation"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Date"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text First Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Note Heading"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Body Text Indent 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Block Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Hyperlink"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="FollowedHyperlink"/>
<w:LsdException Locked="false" Priority="22" QFormat="true" Name="Strong"/>
<w:LsdException Locked="false" Priority="20" QFormat="true" Name="Emphasis"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Document Map"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Plain Text"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="E-mail Signature"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Top of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Bottom of Form"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal (Web)"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Acronym"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Address"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Cite"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Code"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Definition"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Keyboard"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Preformatted"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Sample"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Typewriter"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="HTML Variable"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Normal Table"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="annotation subject"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="No List"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Outline List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Simple 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Classic 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Colorful 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Columns 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Grid 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 4"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 5"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 6"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 7"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table List 8"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table 3D effects 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Contemporary"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Elegant"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Professional"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Subtle 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 1"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 2"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Web 3"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Balloon Text"/>
<w:LsdException Locked="false" Priority="39" Name="Table Grid"/>
<w:LsdException Locked="false" SemiHidden="true" UnhideWhenUsed="true"
Name="Table Theme"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Placeholder Text"/>
<w:LsdException Locked="false" Priority="1" QFormat="true" Name="No Spacing"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading"/>
<w:LsdException Locked="false" Priority="61" Name="Light List"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 1"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 1"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 1"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 1"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 1"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 1"/>
<w:LsdException Locked="false" SemiHidden="true" Name="Revision"/>
<w:LsdException Locked="false" Priority="34" QFormat="true"
Name="List Paragraph"/>
<w:LsdException Locked="false" Priority="29" QFormat="true" Name="Quote"/>
<w:LsdException Locked="false" Priority="30" QFormat="true"
Name="Intense Quote"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 1"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 1"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 1"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 1"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 1"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 1"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 1"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 1"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 2"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 2"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 2"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 2"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 2"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 2"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 2"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 2"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 2"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 2"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 2"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 2"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 2"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 2"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 3"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 3"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 3"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 3"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 3"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 3"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 3"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 3"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 3"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 3"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 3"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 3"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 3"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 3"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 4"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 4"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 4"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 4"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 4"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 4"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 4"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 4"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 4"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 4"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 4"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 4"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 4"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 4"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 5"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 5"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 5"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 5"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 5"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 5"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 5"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 5"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 5"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 5"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 5"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 5"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 5"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 5"/>
<w:LsdException Locked="false" Priority="60" Name="Light Shading Accent 6"/>
<w:LsdException Locked="false" Priority="61" Name="Light List Accent 6"/>
<w:LsdException Locked="false" Priority="62" Name="Light Grid Accent 6"/>
<w:LsdException Locked="false" Priority="63" Name="Medium Shading 1 Accent 6"/>
<w:LsdException Locked="false" Priority="64" Name="Medium Shading 2 Accent 6"/>
<w:LsdException Locked="false" Priority="65" Name="Medium List 1 Accent 6"/>
<w:LsdException Locked="false" Priority="66" Name="Medium List 2 Accent 6"/>
<w:LsdException Locked="false" Priority="67" Name="Medium Grid 1 Accent 6"/>
<w:LsdException Locked="false" Priority="68" Name="Medium Grid 2 Accent 6"/>
<w:LsdException Locked="false" Priority="69" Name="Medium Grid 3 Accent 6"/>
<w:LsdException Locked="false" Priority="70" Name="Dark List Accent 6"/>
<w:LsdException Locked="false" Priority="71" Name="Colorful Shading Accent 6"/>
<w:LsdException Locked="false" Priority="72" Name="Colorful List Accent 6"/>
<w:LsdException Locked="false" Priority="73" Name="Colorful Grid Accent 6"/>
<w:LsdException Locked="false" Priority="19" QFormat="true"
Name="Subtle Emphasis"/>
<w:LsdException Locked="false" Priority="21" QFormat="true"
Name="Intense Emphasis"/>
<w:LsdException Locked="false" Priority="31" QFormat="true"
Name="Subtle Reference"/>
<w:LsdException Locked="false" Priority="32" QFormat="true"
Name="Intense Reference"/>
<w:LsdException Locked="false" Priority="33" QFormat="true" Name="Book Title"/>
<w:LsdException Locked="false" Priority="37" SemiHidden="true"
UnhideWhenUsed="true" Name="Bibliography"/>
<w:LsdException Locked="false" Priority="39" SemiHidden="true"
UnhideWhenUsed="true" QFormat="true" Name="TOC Heading"/>
<w:LsdException Locked="false" Priority="41" Name="Plain Table 1"/>
<w:LsdException Locked="false" Priority="42" Name="Plain Table 2"/>
<w:LsdException Locked="false" Priority="43" Name="Plain Table 3"/>
<w:LsdException Locked="false" Priority="44" Name="Plain Table 4"/>
<w:LsdException Locked="false" Priority="45" Name="Plain Table 5"/>
<w:LsdException Locked="false" Priority="40" Name="Grid Table Light"/>
<w:LsdException Locked="false" Priority="46" Name="Grid Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="Grid Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="Grid Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="Grid Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="Grid Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="Grid Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="Grid Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="Grid Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="Grid Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="Grid Table 7 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="46" Name="List Table 1 Light"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark"/>
<w:LsdException Locked="false" Priority="51" Name="List Table 6 Colorful"/>
<w:LsdException Locked="false" Priority="52" Name="List Table 7 Colorful"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 1"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 1"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 1"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 1"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 1"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 1"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 2"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 2"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 2"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 2"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 2"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 2"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 3"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 3"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 3"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 3"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 3"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 3"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 4"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 4"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 4"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 4"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 4"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 4"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 5"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 5"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 5"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 5"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 5"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 5"/>
<w:LsdException Locked="false" Priority="46"
Name="List Table 1 Light Accent 6"/>
<w:LsdException Locked="false" Priority="47" Name="List Table 2 Accent 6"/>
<w:LsdException Locked="false" Priority="48" Name="List Table 3 Accent 6"/>
<w:LsdException Locked="false" Priority="49" Name="List Table 4 Accent 6"/>
<w:LsdException Locked="false" Priority="50" Name="List Table 5 Dark Accent 6"/>
<w:LsdException Locked="false" Priority="51"
Name="List Table 6 Colorful Accent 6"/>
<w:LsdException Locked="false" Priority="52"
Name="List Table 7 Colorful Accent 6"/>
</w:LatentStyles>
</xml><![endif]-->
<style>
<!--@font-face
{src: url('[Link]
format('truetype');}
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;
mso-font-charset:0;
mso-generic-font-family:roman;
mso-font-pitch:variable;
mso-font-signature:-536869121 1107305727 33554432 0 415 0;}
@font-face
{font-family:"RS Hindi";
mso-font-charset:0;
mso-generic-font-family:auto;
mso-font-pitch:auto;
mso-font-signature:0 0 0 0 0 0;}
/* Style Definitions */
[Link], [Link], [Link]
{mso-style-unhide:no;
mso-style-qformat:yes;
mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman",serif;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;}
p
{mso-style-noshow:yes;
mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman",serif;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;}
p.msonormal0, li.msonormal0, div.msonormal0
{mso-style-name:msonormal;
mso-style-unhide:no;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman",serif;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;}
[Link], [Link], [Link]
{mso-style-name:fontsrshh;
mso-style-unhide:no;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
font-size:19.0pt;
font-family:"RS Hindi";
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-bidi-font-family:"Times New Roman";}
[Link]
{mso-style-name:"";
mso-spl-e:yes;}
[Link]
{mso-style-name:"";
mso-gram-e:yes;}
.MsoChpDefault
{mso-style-type:export-only;
mso-default-props:yes;
font-size:10.0pt;
mso-ansi-font-size:10.0pt;
mso-bidi-font-size:10.0pt;}
@page WordSection1
{size:595.3pt 841.9pt;
margin:28.4pt 21.3pt 72.0pt 1.0cm;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
[Link]
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman",serif;}
</style>
<![endif]-->
<meta charset=utf-8>
<meta name=viewport content="width=device-width, initial-scale=0.1">
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1027"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-IN style='tab-interval:36.0pt'>
<div class=WordSection1>
<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes;
height:59.4pt'>
<td width="9%" style='width:9.12%;padding:.75pt .75pt .75pt .75pt;height:
59.4pt'>
<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><span
style='font-size:11.5pt;mso-fareast-font-family:"Times New
Roman"'>Date<o:p></o:p></span></b></p>
<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><span
style='font-size:11.5pt;mso-fareast-font-family:"Times New Roman"'>14.02.25
<o:p></o:p></span></b></p>
</td>
<td width="69%" style='width:69.68%;padding:.75pt .75pt .75pt .75pt;
height:59.4pt'>
<p class=MsoNormal align=center style='margin-left:19.75pt;text-
align:center'><!--[if gte vml 1]><v:shapetype
id="_x0000_t75" coordsize="21600,21600" o:spt="75" o:preferrelative="t"
path="m@4@5l@4@11@9@11@9@5xe" filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="Picture_x0020_3" o:spid="_x0000_s1026"
type="#_x0000_t75"
alt="A2FD138A" style='position:absolute;left:0;text-align:left;
margin-left:5.25pt;margin-top:3.8pt;width:26.55pt;height:29.8pt;z-
index:251661312;
visibility:visible;mso-wrap-style:square;mso-width-percent:0;
mso-height-percent:0;mso-wrap-distance-left:9pt;mso-wrap-distance-top:0;
mso-wrap-distance-right:9pt;mso-wrap-distance-bottom:0;
mso-position-horizontal:absolute;mso-position-horizontal-relative:text;
mso-position-vertical:absolute;mso-position-vertical-relative:text;
mso-width-percent:0;mso-height-percent:0;mso-width-relative:page;
mso-height-relative:page'>
<v:imagedata src="IP%20with%20Python%20(10)_files/[Link]"
o:title="A2FD138A"/>
</v:shape><![endif]--><![if !vml]><span style='mso-ignore:vglayout;
position:absolute;z-index:251661312;left:0px;margin-left:7px;margin-top:5px;
width:35px;height:40px'><img width=35 height=40
src="IP%20with%20Python%20(10)_files/[Link]" alt=A2FD138A
v:shapes="Picture_x0020_3"></span><![endif]><a
name="RANGE!A1:J34"></a><span style='mso-bookmark:"RANGE\!A1\:J34"'><b><span
style='font-size:8.0pt;mso-fareast-font-family:"Times New
Roman";color:black'>KAMARAJ
INTERNATIONAL ACADEMY SENIOR SECONDARY SCHOOL (CBSE<span class=GramE>)</span><br>
AFFILIATED TO CBSE, NEW DELHI.<span style='mso-spacerun:yes'>
</span>AFFILIATION NO: 1931446<br>
PASUVANTHUNAI ROAD, PANDAVARMANGALAM, KOVILPATTI-
628502</span></b></span><b><span
style='font-size:8.0pt;mso-fareast-font-family:"Times New
Roman";color:black'><o:p></o:p></span></b></p>
<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><span
style='font-size:10.0pt;mso-fareast-font-family:"Times New
Roman"'><o:p> </o:p></span></b></p>
<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><span
style='font-size:10.0pt;mso-fareast-font-family:"Times New Roman"'>Subject :
COMPUTER
SCIENCE <o:p></o:p></span></b></p>
<p class=MsoNormal><b style='mso-bidi-font-weight:normal'><span
style='font-size:10.0pt;mso-fareast-font-family:"Times New Roman"'>Class : <span
style='mso-spacerun:yes'> </span>XII <o:p></o:p></span></b></p>
</td>
<td width="20%" style='width:20.12%;padding:.75pt .75pt .75pt .75pt;
height:59.4pt'>
<div>
<p class=MsoNormal><span style='font-size:11.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman"'>Time – 1 hrs 20 <span
class=SpellE>mins</span> <o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:11.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman"'><span
style='mso-spacerun:yes'> </span>MM : 40<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>1.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Fill in the
Blanks.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>Select * from student where <span
class=SpellE>admno</span> between 1101 _______ 1199<span
class=GramE>;.</span><o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>2.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Fill in the
Blanks.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>____________ <span
class=GramE>command</span> is used to view the structure of the
table.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>3.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>State TRUE or
FALSE.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>DELETE is DDL
command.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>4.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>State TRUE or
FALSE.<o:p></o:p></span></p>
<p><span class=GramE><span
style='font-family:"Arial",sans-serif'>COUNT(</span></span><span
style='font-family:"Arial",sans-serif'>) will count NULL
values.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>5.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Define Primary
Key.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>6.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Write the difference between
CHAR and VARCHAR.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>7.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>What is the purpose of
BETWEEN <span class=GramE>Clause</span>?<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>8.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Write the full form of
SQL.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>9.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Which command is used to
change the database?<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(a) Open <o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(b) Change<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(c) Use <o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(d) Select<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>10.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Which is not a category of
SQL command?<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(a) DDL <o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(b) XML<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(c) DML <o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(d) TCL<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>11.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Number of rows in a relation
is known as<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(a) Degree <o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(b)
Cardinality<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(c) Cartesian Product
<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(d)
Attribute<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>12.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>A Table customer contains 5
rows and 7 columns. What will be its cardinality and
degree?<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(<span class=GramE>a</span>)
Degree 7, Cardinality 5.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(b) Degree 5, Cardinality
7.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(c) Degree 5, Cardinality
7.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(d) Cardinality 7, Degree
7.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellspacing=30 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>13.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Observe the following
STUDENTS and EVENTS tables carefully and write the name of the RDBMS
operation which will be used to produce the output as shown in <span
class=GramE>LIST ?</span> Also, find the Degree and Cardinality of the
LIST.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif;mso-no-proof:yes'><img
width=583 height=315 id="_x0000_i1025"
src="[Link]
%20Science/IP%20with%20Python/chapter4/images/[Link]"
alt="[Link]
%20Science/IP%20with%20Python/chapter4/images/[Link]"></span><span
style='font-family:"Arial",sans-serif'><o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'> <o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>2<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>14.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>What is an Alternate
Key?<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>2<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>15.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Observe the table ‘Club’
given below:<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>Table: Club<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=1 cellpadding=0 width=0
style='width:375.0pt;mso-cellspacing:.7pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal align=center style='text-align:center'><span
class=SpellE><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>Member_id</span></span><span style='font-
family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal align=center style='text-align:center'><span
class=SpellE><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>Member_Name</span></span><span style='font-
family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal align=center style='text-align:center'><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'>Address<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal align=center style='text-align:center'><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'>Age<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal align=center style='text-align:center'><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'>Fee<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M001<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Sumit</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>New Delhi<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>20<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2000<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:2'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M002<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Nisha</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Gurgaon<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>19<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>3500<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M003<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Niharika</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>New Delhi<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>21<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2100<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:4;mso-yfti-lastrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M004<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Sachin<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Faridabad<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>18<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>3500<o:p></o:p></span></p>
</td>
</tr>
</table>
<p><span style='font-family:"Arial",sans-serif'>(<span class=SpellE>i</span>)
What is the cardinality and degree of the above given
table?<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(ii) If a new column <span
class=SpellE>contact_no</span> has been added and three more members have
joined the club then how these changes will affect the degree and cardinality
of the above given table.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>3<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>16.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Observe the following table
and answer the parts (<span class=SpellE>i</span>) and (ii)
accordingly<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>Table:
Product<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=1 cellpadding=0 width=0
style='width:225.0pt;mso-cellspacing:.7pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Pno</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Name<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Qty</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>PurchaseDate</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>101<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Pen<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>102<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>12-12-2011<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:2'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>102<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Pencil<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>201<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>21-02-2013<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>103<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Eraser<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>90<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>09-08-2010<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:4'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>109<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Sharpener<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>90<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>31-08-2012<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:5;mso-yfti-lastrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>113<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Clips<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>900<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>12-12-2011<o:p></o:p></span></p>
</td>
</tr>
</table>
<p><span style='font-family:"Arial",sans-serif'>(a) Write the names of most
appropriate columns, which can be considered as candidate
keys.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(b) What is the degree and
cardinality of the above table?<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>3<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>17.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Write SQL commands for the
following:<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>Table:
TEACHER<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=1 cellpadding=0 width=0
style='width:450.0pt;mso-cellspacing:.7pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>TID<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>NAME<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>AGE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DEPT<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DATEOFJOIN<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>SAL<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>SEX<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T118<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Navin</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>40<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Computer<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2010-01-10<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>12000<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:2'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T107<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Chetna</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>37<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>History<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2008-03-24<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>20000<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>F<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T105<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Sandeep<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>46<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Maths<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2006-12-12<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>30000<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:4'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T110<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Sangeeta</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>35<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>History<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2010-07-01<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>25000<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>F<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:5'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T101<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Rudransh</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>42<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Maths<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2004-09-05<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>40000<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:6;mso-yfti-lastrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T121<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Neeraj</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>38<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Physics<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2011-04-01<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>28000<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M<o:p></o:p></span></p>
</td>
</tr>
</table>
<p><span style='font-family:"Arial",sans-serif'>(<span class=SpellE>i</span>)
To show information about the teachers of the history
department.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(ii) To list the names of
teachers earning a salary between 20000 and 30000.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(iii) To count the number of
male teachers.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(iv) Display gender wise
total number of teachers.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(v) To list the name and age
of teachers of female teachers in descending order of date of
join.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(vi) Increase the salary by
10% for Maths departments.<o:p></o:p></span></p>
<p><span class=GramE><span style='font-family:"Arial",sans-serif'>(
vii</span></span><span
style='font-family:"Arial",sans-serif'>) To delete the record of teacher <span
class=SpellE>Neeraj</span>.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>4<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>18.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Consider the following table
HOSPITAL.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>Table:
HOSPITAL<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=1 cellpadding=0 width=0
style='width:450.0pt;mso-cellspacing:.7pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>PNo</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Name<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Age<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Department<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>DateofAdm</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Charges<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Sex<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Mayank</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>65<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Surgery<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>23/02/2018<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>600<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:2'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Babita</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>24<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>ENT<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>01/01/2019<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>400<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>F<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>3<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Kashish</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>45<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Orthopaedic<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>19/12/2018<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>400<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:4'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>4<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Tarun</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>12<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Surgery<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>01/10/2018<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>600<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:5'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>5<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Manisha<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>36<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>ENT<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>12/01/2018<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>400<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>F<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:6'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>6<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Imran<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>16<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>ENT<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>24/02/2018<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>400<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:7'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>7<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Ankita</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>NULL<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Cardiology<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>20/08/2018<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>800<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>F<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:8'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>8<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Zoya</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>45<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Gynecology</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>22/02/2018<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>500<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>F<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:9'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>9<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Kush<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>19<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Cardiology<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>13/01/2019<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>800<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>M<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:10;mso-yfti-lastrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>10<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Shalini</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>31<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Medicine<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>19/02/2018<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>300<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>F<o:p></o:p></span></p>
</td>
</tr>
</table>
<p><span style='font-family:"Arial",sans-serif'>Note: <span
class=SpellE>PNo</span>
is the primary key in the above table.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>Write SQL commands for the
statements (a) to (g) on the table HOSPITAL.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(a) To show all the
information about the patients of the cardiology
department.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(b) To list the names of
female patients who are either in the orthopaedic or surgery
department.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(c) To list the name of all
the patients with their date of admission in ascending
order.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(d) To display the patient’s
name, charges, the age for female patients only.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(e) To count the number of
patients with age > 30.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(f) To display various
departments.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(g) To display the number of
patients in each department.<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>4<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>19.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Write SQL queries for (a) to
(f) and write the outputs for the SQL queries mentioned shown in (g1) to (g4)
parts on the basis of tables ITEMS and TRADERS:
[Delhi 2013]<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>Table:
ITEMS<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=1 cellpadding=0 width=0
style='width:375.0pt;mso-cellspacing:.7pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>CODE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>INAME<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>QTY<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>PRICE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>COMPANY<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>TCODE<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1001<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DIGITAL<br>
PAD 12i<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>120<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>11000<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>XENITA<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T01<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:2'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1006<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>LED<br>
SCREEN 40<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>70<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>38000<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>SANTORA<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T02<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1004<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>CAR GPS<br>
SYSTEM<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>50<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>21500<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>GEOKNOW<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T01<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:4'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1003<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DIGITAL<br>
CAMERA<br>
12X<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>160<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>8000<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DIGICLICK<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T02<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:5;mso-yfti-lastrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1005<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>PEN DRIVE<br>
32GB<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>600<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1200<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>STOREHOME<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T03<o:p></o:p></span></p>
</td>
</tr>
</table>
<p><span style='font-family:"Arial",sans-serif'>Table:
TRADERS<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=1 cellpadding=0 width=0
style='width:225.0pt;mso-cellspacing:.7pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>TCode</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>TName</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>CITY<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T01<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>ELECTRONIC SALES<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>MUMBAI<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:2'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T03<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>BUSY STORE CORP<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DELHI<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>T02<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DISP HOUSE INC<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>CHENNAI<o:p></o:p></span></p>
</td>
</tr>
</table>
<p><span style='font-family:"Arial",sans-serif'>(a) To display the details of
all the items in the ascending order of item names (i.e.
INAME).<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(b) To display item name and
price of all those items, whose price is in range of 10000 and 22000 (both
values inclusive).<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(c) To display the number of
items, which are traded by each trader. The expected output of this query
should be:<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>T01 2<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>T02 2<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>T03 1<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(d) To display the price,
item name and quantity (i.e. <span class=SpellE>qty</span>) of those items
which have quantity more than 150.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(e) To display the names of
those traders, who are either from DELHI or from <span
class=GramE>MUMBAI.</span><o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(f) To display the names of
the companies and the names of the items in descending order of company
names.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(g1) Select max(price),
min(price) from items; (g2) Select price*<span class=SpellE>qty</span> amount
from items where code=1004;<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(g3) Select distinct <span
class=SpellE>tcode</span> from items; (g4) Select <span
class=SpellE>iname</span>,
<span class=SpellE>tname</span> from items <span class=SpellE>i</span>,
traders t where <span class=SpellE>[Link]</span>=<span
class=SpellE>[Link]</span>
and <span class=SpellE>qty</span><100;<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>5<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span lang=EN style='font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";display:none;mso-hide:all;mso-ansi-
language:
EN'><o:p> </o:p></span></p>
<table class=MsoNormalTable border=0 cellpadding=0 width="100%"
style='width:100.0%;mso-cellspacing:1.5pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-row-margin-right:30.75pt'>
<td style='padding:.75pt .75pt .75pt .75pt'></td>
<td style='mso-cell-special:placeholder;border:none;padding:0cm 0cm 0cm 0cm'
width=41 colspan=2><p class='MsoNormal'> </td>
</tr>
<tr style='mso-yfti-irow:1;mso-yfti-lastrow:yes'>
<td width="2%" valign=top style='width:2.0%;padding:3.75pt .75pt 3.75pt .75pt'>
<p class=MsoNormal><span style='font-size:13.5pt;font-family:"Arial",sans-serif;
mso-fareast-font-family:"Times New Roman";color:black'>20.<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p><span style='font-family:"Arial",sans-serif'>Consider the following DEPT
and WORKER tables. Write SQL queries for (<span class=SpellE>i</span>) to
(iv) and find outputs for SQL queries (v) to
(viii): [Delhi 2015]<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>Table: DEPT<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=1 cellpadding=0 width=0
style='width:225.0pt;mso-cellspacing:.7pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DCODE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DEPARTMENT<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>CITY<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D01<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>MEDIA<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DELHI<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:2'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D02<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>MARKETING<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DELHI<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D03<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>INFRASTRUCTURE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>MUMBAI<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:4'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D05<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>FINANCE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>KOLKATA<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:5;mso-yfti-lastrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D04<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>HUMAN RESOURCE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>MUMBAI<o:p></o:p></span></p>
</td>
</tr>
</table>
<p><span style='font-family:"Arial",sans-serif'>Table:
WORKER<o:p></o:p></span></p>
<table class=MsoNormalTable border=1 cellspacing=1 cellpadding=0 width=0
style='width:450.0pt;mso-cellspacing:.7pt;mso-yfti-tbllook:1184'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>WNO<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>NAME<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DOJ<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DOB<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>GENDER<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>DCODE<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:1'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1001<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>George K<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2013-09-02<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1991-09-01<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>MALE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D01<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:2'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1002<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Ryma</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'>
Sen<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2012-12-11<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1990-12-15<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>FEMALE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D03<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1003<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span class=SpellE><span style='font-family:"Arial",sans-
serif;
mso-fareast-font-family:"Times New Roman"'>Mohitesh</span></span><span
style='font-family:"Arial",sans-serif;mso-fareast-font-family:"Times New
Roman"'><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2013-02-03<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1987-09-04<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>MALE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D05<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:4'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1007<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Anil <span class=SpellE>Jha</span><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2014-01-17<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1984-10-19<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>MALE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D04<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:5'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1004<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Manila <span class=SpellE>Sahai</span><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2012-12-09<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1986-11-14<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>FEMALE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D01<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:6'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1005<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>R SAHAY<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2013-11-18<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1987-03-31<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>MALE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D02<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:7;mso-yfti-lastrow:yes'>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1006<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>Jaya <span class=SpellE>Priya</span><o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>2014-06-09<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>1985-06-23<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>FEMALE<o:p></o:p></span></p>
</td>
<td style='padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-
font-family:
"Times New Roman"'>D05<o:p></o:p></span></p>
</td>
</tr>
</table>
<p><span style='font-family:"Arial",sans-serif'>Note: DOJ refers to date of
joining and DOB refers to date of Birth of workers.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(<span class=SpellE>i</span>)
To display <span class=SpellE>Wno</span>, Name, Gender from the table WORKER
in descending order of <span class=SpellE>Wno</span>.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(ii) To display the Name of
all the FEMALE workers from the table WORKER.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(iii) To display the <span
class=SpellE>Wno</span> and Name of those workers from the table WORKER who
are born between ‘1987-01-01’ and ‘1991-12-01’.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(iv) To count and display
MALE workers who have joined after ‘1986-01-01’.<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(v) SELECT COUNT(*), DCODE
FROM WORKER GROUP BY DCODE HAVING COUNT(*)>1;<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(vi) SELECT DISTINCT
DEPARTMENT FROM DEPT;<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(vii) SELECT NAME,
DEPARTMENT, CITY FROM WORKER W,DEPT D WHERE [Link]=[Link] AND
WNO<1003;<o:p></o:p></span></p>
<p><span style='font-family:"Arial",sans-serif'>(viii) SELECT MAX(DOJ),
MIN(DOB) FROM WORKER;<o:p></o:p></span></p>
</td>
<td width="2%" style='width:2.0%;padding:.75pt .75pt .75pt .75pt'>
<p class=MsoNormal><span style='font-family:"Arial",sans-serif;mso-fareast-font-
family:
"Times New Roman"'>5<o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><span style='mso-fareast-font-family:"Times New
Roman"'><o:p> </o:p></span></p>
</div>
</body>
</html>
You might also like
- Microsoft PowerPoint - E-MIAS Manual For School Authority - English - 23!6!2020No ratings yetMicrosoft PowerPoint - E-MIAS Manual For School Authority - English - 23!6!202057 pages
- Magnetic Levitation Train Project ReportNo ratings yetMagnetic Levitation Train Project Report2 pages
- Understanding Surface Friction in PhysicsNo ratings yetUnderstanding Surface Friction in Physics3 pages
- SQL Commands for Class XII Computer ScienceNo ratings yetSQL Commands for Class XII Computer Science5 pages
- Class XII Biology Full Portion Test 2024-25No ratings yetClass XII Biology Full Portion Test 2024-256 pages
- SQL Queries for Student and Employee DataNo ratings yetSQL Queries for Student and Employee Data7 pages
- Class 12 IP: Pandas Data Handling Solutions100% (1)Class 12 IP: Pandas Data Handling Solutions10 pages
- Python Code Output Predictions and SQL QueriesNo ratings yetPython Code Output Predictions and SQL Queries9 pages
- Teacher Salary Analysis at Satish Chandra SchoolNo ratings yetTeacher Salary Analysis at Satish Chandra School7 pages
- Budget-Friendly Beta Test Planning GuideNo ratings yetBudget-Friendly Beta Test Planning Guide60 pages
- Software Testing Principles & Types GuideNo ratings yetSoftware Testing Principles & Types Guide16 pages
- Java + Spring Boot Interview Prep OutlineNo ratings yetJava + Spring Boot Interview Prep Outline7 pages
- K.C.S.E 2018 Computer Studies Exam PaperNo ratings yetK.C.S.E 2018 Computer Studies Exam Paper12 pages
- Daytona USA: Classic Arcade Racing GameNo ratings yetDaytona USA: Classic Arcade Racing Game11 pages
- Simpson's Rule for Irregular Data in ExcelNo ratings yetSimpson's Rule for Irregular Data in Excel9 pages
- Modern Distributed Systems with MicroservicesNo ratings yetModern Distributed Systems with Microservices8 pages
- LED Illuminated Display LWA-90 SpecificationsNo ratings yetLED Illuminated Display LWA-90 Specifications1 page