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]
4 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]4 years ago
3 0
Bader Ali, IT101, from Ahmad Nasser where Bader Ali GPA=2.
You might be interested in
WILL GIVE BRAINLIEST!!!!!!!
stellarik [79]
True











Dhahvdbdbrhhehebdbdbbdbd sorry it has to be longer ahhshdjdjhsjdjdbdnbfbfjfj
7 0
3 years ago
Read 2 more answers
Write an expression that executes the loop body as long as the user enters a non-negative number. Note: If the submitted code ha
Mama L [17]

In the program While loop is used. In the while loop it divides the userNum by 2 in each iteration and prints the value of userNum. The inputs and corresponding outputs are written in the explanation.

<u>Explanation</u>:

In the while loop it divides the userNum by 2 in each iteration and prints the value of userNum.

import java.util.Scanner;  

public class NonNegativeLooper

public static void main (String [] args)

Scanner scnr = new Scanner(System.in);  

//initialize the userNum with 9

int userNum = 9;

//Repeat the loop until the userNum is not negative

while (userNum>=0)

System.out.println(Body);

//Prompt the user to enter the usrNum again

userNum = scnr.nextInt();

System.out.println(Done.);

return;

8 0
4 years ago
Write a method named countInRange that accepts three parameters: an ArrayList of integers, a minimum and maximum integer, and re
marissa [1.9K]

Answer:

In Java:

The method is as follows:

public static int countInRange (ArrayList<Integer> MyList, int min, int max) {  

       int count = 0;

       for (int i = 0; i < MyList.size(); i++)  {

           if(MyList.get(i)>=min && MyList.get(i)<=max){

               count++;

           }  

       }

       return count;

 }

Explanation:

This defines the method

public static int countInRange (ArrayList<Integer> MyList, int min, int max) {

This declares and initializes count to 0  

       int count = 0;

This iterates through the ArrayList

       for (int i = 0; i < MyList.size(); i++)  {

This checks if current ArrayList element is between min and max (inclusive)

           if(MyList.get(i)>=min && MyList.get(i)<=max){

If yes, increase count by 1

               count++;

           }  

       }

This returns count

       return count;

 }

To call the method from main, use:

countInRange(v,m,n)

<em>Where v is the name of the ArrayList, m and n are the min and max respectively.</em>

6 0
3 years ago
ACME Corp. is developing a software program that can run on mobile devices so that customers can interact with the firm, view pr
dimaraw [331]

Answer:

App is the correct answer of this question.

Explanation:

ACME Corp. is creating a computer program that can run on mobile devices to allow clients to communicate with the business, display product information and order status.This is best represented as app.

<u>For Example</u>:- Music,Playing games,text,video chatting,Shopping Online and Planning vacations etc.  

  • An app is a software category that allows you manage complex tasks.
  • Tablet or smartphone apps are sometimes pointed to as web browsers, while those for mobile devices are pointed to as apps and websites.

5 0
3 years ago
What citation style should I use if applying for a government job?
maw [93]
You should always cite your sources with a referral to the person.
3 0
3 years ago
Other questions:
  • What do you think of my profile picture
    8·2 answers
  • All of the following are forms of verbal communication except
    12·2 answers
  • All the following are graphic file formats except<br>HTML<br>BMP<br>png<br>Tiff​
    5·1 answer
  • Package Newton’s method for approximating square roots (Case Study: Approximating Square Roots) in a function named newton. This
    7·1 answer
  • In the library 6 students are working on math. of those 6 students 2/3 of them are working on fractions. how many students are w
    13·1 answer
  • If you have _____, you can evaluate whether information is misleading, biased, or out of date. Group of answer choices informati
    7·1 answer
  • Write steps to Delete data from ‘Datagridview’
    6·1 answer
  • Which of the following is true about advertisements?
    15·1 answer
  • Where can elicitation techniques be used?
    12·1 answer
  • When you set code inside other code, in an orderly fashion, it is called:
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!