1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Amiraneli [1.4K]
3 years ago
6

A database interrogation is a major benefit of the database management approach, where end users can query (“ask”) the database

for information. The Structured Query Language (SQL) is an international standard query language found in many DBMS packages. The basic form of a SQL query is: SELECT . . . FROM . . . WHERE . . .
For example, if we have the following STUDENTS table:

STUDENT_ID STUDENT_NAME COURSE_ID STUDENT_GPA COLLEGE_CODE

140064001 Ahmad Nasser IT101 3.5 CHS

140064002 Sarah Abdullah IT343 2.75 CCI

140064003 Sultan Mohamed IT242 3.15 CCI

140064004 Basmah Khaled IT446 3.90 CCI

140064005 Bader Ali IT101 2.90 CHI

140064006 Fahad Mutlaq IT448 1.95 CCI

140064007 Salman Abdulaziz IT242 2.90 CCI


The following SQL query is used to retrieve STUDENT_NAME and COURSE_ID for all students who have GPA = 2.90


SELECT [STUDENT_NAME], [COURSE_ID]

FROM [STUDENTS]

WHERE [STUDENT_GPA] = 2.90
Computers and Technology
1 answer:
sp2606 [1]3 years ago
3 0
Bader Ali, IT101, from Ahmad Nasser where Bader Ali GPA=2.
You might be interested in
Which option is not a tab type?
BlackZzzverrR [31]

Answer:

its right i think

Explanation:

7 0
3 years ago
Create an application containing an array that stores eight integers. The application should call five methods that in turn (1)
Butoxors [25]

Answer:

package b4;

public class ArrayMethodDemo {

public static void main(String[] args) {

 // Create an array to store 8 random integers.

 int[] integernumbers = { 3, 4, 6, 9, 5, 6, 7, 2 };

 // Call the display method to show the elements in the array.

 display(integernumbers);

 // Call the method to display the elements in reverse order.

 displayReverse(integernumbers);

 // Call the method to find the sum of the elements.

 sum(integernumbers);

 // Call the method to display all elements less than a limiting value, say 5.

 lessThan(integernumbers, 5);

 // Call the method to display all elements greater than the average of the array

 // elements.

 higherThan(integernumbers);

}

// Method to display the elements in the array.

// The method receives only a single argument which is the array.

// Loop through the array and at every cycle, print out each element

public static void display(int[] arr) {

 System.out.print("All integers in the array : ");

 for (int i = 0; i < arr.length; i++) {

  System.out.print(arr[i] + " ");

 }

 System.out.println();

}

// Method to display the elements in the array in reverse order

// The method receives only a single parameter which is the array

// Loop through the array starting at the last index

// At every cycle, print out the elements in the array

public static void displayReverse(int[] arr) {

 System.out.print("All integers in the array in reverse : ");

 for (int i = arr.length - 1; i >= 0; i--) {

  System.out.print(arr[i] + " ");

 }

 System.out.println();

}

// Method to print out the sum of the elements in the array.

// The method receives only a single parameter which is the array.

// Declare a variable called sum to hold the sum of the elements

// Initialize sum to zero

// Loop through the array and cumulatively add each element to sum

// Print out the sum at the end of the loop

public static void sum(int[] arr) {

 int sum = 0;

 for (int i = 0; i < arr.length; i++) {

  sum += arr[i];

 }

 System.out.println("The sum of the integers in the array is " + sum);

}

// Method to print all values in the array that are less than a limiting

// argument.

// The method has two parameters - the array and the limiting argument.

// Loop through the array and at every cycle,

// check if the current array element is less than the limiting argument.

// If it is, print it out. Else continue

public static void lessThan(int[] arr, int limitingargument) {

 System.out.print("All values less than the limiting argument (" + limitingargument + ") are: ");

 for (int i = 0; i < arr.length; i++) {

  if (arr[i] < limitingargument) {

   System.out.print(arr[i] + " ");

  }

 }

 System.out.println();

}

// Method to print all values in the array that are higher than the average of

// the array.

// The method has one parameter - the array.

// First, calculate the average of the array elements.

// Loop through the array and at every cycle,

// check if the current array element is greater than the average.

// If it is, print it out. Else continue

public static void higherThan(int[] arr) {

 int sum = 0;

 for (int i = 0; i < arr.length; i++) {

  sum += arr[i];

 }

 double average = sum / arr.length;

 System.out.print("All values higher than the calculate average (" + average + ") is ");

 for (int i = 0; i < arr.length; i++) {

  if (arr[i] > average) {

   System.out.print(arr[i] + " ");

  }

 }

 System.out.println();

}

}

Explanation:

The program has been written in Java.

Please go through the comments in the code for explanation.

The source code has also been attached to this response.

Hope this helps!

Download java
3 0
3 years ago
Is there anybody who knows eris quirk but me- i feel lonely rn ;-;
Nutka1998 [239]

Answer:i do Eri's Quirk allows her to rewind an individual's body to a previous state. She has shown the ability to rewind someone's body to a point before they existed, which she accidentally did to her father.

3 0
3 years ago
Read 2 more answers
Do u like five nights at Freddy's? and is it good or bad?​
Murljashka [212]

Answer:

its bad

Explanation:

6 0
3 years ago
Read 3 more answers
Which is correct? And for the second one the drop down answers are 1. Leadership
SIZIF [17.4K]

Answer:

It is a spreadsheet application. the second should be leadership

4 0
3 years ago
Read 2 more answers
Other questions:
  • List the data types that are allowed for SQL attributes.
    7·1 answer
  • Ryan needs to see the space available to insert content on a slide in his presentation. Which feature of a presentation program
    5·1 answer
  • Whats my screen name?
    9·2 answers
  • Jacob would like to include an arrow in his newsletter to point to some important information. He should _____.
    14·2 answers
  • What is one way to improve the upward flow of information?
    12·1 answer
  • What pointer appears when pointing to a hyperlink?
    9·1 answer
  • Help! I’ll mark you brainly! Please help me.
    15·1 answer
  • Can i get some help please .
    5·2 answers
  • NEED ANS ASAP THANK YOU
    14·1 answer
  • Question: 4/8
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!