Search
Ques- create a SQL query .....on
Table : STUDENT
Admno 101 , 102 , 103 , 104 & 105
Name
Ayushi
heena
Jitender
meena
Marks
52, 95 , 89 , 65 ,98
1) Write a create table query
2) To displey al details of all students.
3) To dsplay al details in descending order of marks.
4) To display admno and name of all students whose name starts with 'A.
4 To display the maximum and minimum marks from the table students
5) To dsplay al details of students whose marks are between 80 to 95 inclusive
Write a program using integers userNum and x as input, and output userNum divided by x three times.
Ex: If the input is:
2000 2the output is:
1000 500 250Note: In C++, integer division discards fractions. Ex: 6 / 4 is 1 (the 0.5 is discarded).
A year in the modern Gregorian Calendar consists of 365 days. In reality, the earth takes longer to rotate around the sun. To account for the difference in time, every 4 years, a leap year takes place. A leap year is when a year has 366 days: An extra day, February 29th. The requirements for a given year to be a leap year are:
You can get the character (letter) at the nth index in a string by writing stringVar.charAt(n) or simply stringVar[n]. The returned value will be a string containing only one character (for example, "a"). The first character position is index 0, which causes the last one to be found at position stringVar.length - 1. In other words, an 8 character string has length 8, and its characters have positions 0 and 7. 1. Prompt the user for a string. 2. Write a function called three that will: take a string as a parameter return the 3rd character of the string 3. Display the original string and the result of the function, seperated by a colon (:), to the console. 4. Modify the function so that if the string is shorter than 3 characters it will return the string "too short". 5. Modify the function so that if the third character is a space it will return the word "space". Sample Output User enters "Canada", output: Canada: n; User enters "Of course
Ques- create a SQL query .....on
Table : STUDENT
Admno 101 , 102 , 103 , 104 & 105
Name
Ayushi
heena
Jitender
meena
Marks
52, 95 , 89 , 65 ,98
1) Write a create table query
2) To displey al details of all students.
3) To dsplay al details in descending order of marks.
4) To display admno and name of all students whose name starts with 'A.
4 To display the maximum and minimum marks from the table students
5) To dsplay al details of students whose marks are between 80 to 95 inclusive
Posted about 6 hours ago
Write a program to take a String as input then display the words in one column, number of characters in each word in second column and the first letter of each word in third column with appropriate heading.
For example:
Enter a String
Hello world
Words Length First Letter
Hello 5 H
world 5 w
for(i=0;i<s.lastIndexOf(' ');i++) {
c = s.charAt(i);
if(c ==' ')
s1=s1+s.charAt(i+1)+" ";
} //Use this code for first letter
for(i=0;i<s.length();i++) {
c = s.charAt(i);
if (c != ' ')
n = n+c;
else {
System.out.println(n+...);
} //Use this code for display words and its number of characters
1. Consider the following data to answer the question below
What is the command to convert the above dictionary into a dataframe named ‘df_state’?
2. List 3 commands to display the columns of the above dataframe df_state.
3. Correlation between two variables X&Y is 0.85. Now, after adding the value 2 to all the values of X, the correlation co-efficient will be______
4. A) Read the given dataset “Tips.csv” as a dataframe “Data”. Give 3 commands to extract the columns in the following sequence - Time, TotalBill, Tips?
B) Read the given excel sheet ‘Tips1.xlsx’ as a dataframe ‘Data1’. What command should be given to merge the two data frames ‘Data’ and ‘Data1’ by columns?
C) Copy the 'Data1' dataframe as 'Data2' (Data2 = Data1.copy()) and identify the command to find the total tips received across Day’s from the dataframe ‘Data2’?
Write a program which converts infix expression entered by the user into postfix expression.
Requirements:
Implement this using arrays
Make functions
No global decelerations
Run test in main
Ques- create a SQL query .....on
Table : STUDENT
Admno 101 , 102 , 103 , 104 & 105
Name
Ayushi
heena
Jitender
meena
Marks
52, 95 , 89 , 65 ,98
1) Write a create table query
2) To displey al details of all students.
3) To dsplay al details in descending order of marks.
4) To display admno and name of all students whose name starts with 'A.
4 To display the maximum and minimum marks from the table students
5) To dsplay al details of students whose marks are between 80 to 95 inclusive
Ques- Write a code in Netbeans Java that will ask for item code, Item name and price of 3 items and display all information of all items
#339914 on Dec 2023