Urgent help needed in sql queries ! Thanx :) Question #1 - Find all prime number

Question

Urgent help needed in sql queries ! Thanx :)

Question #1 - Find all prime numbers between 1 and 10,000. Using T-SQL,

code something that prints to the message window (using PRINT) any number between 1 and 10k that is

prime.

Use good code formatting - indentation and whitespace. Your algorithm can be as sophisticated as you

want it to be (don't have to make this super efficient). A list of prime numbers can be

found at https://primes.utm.edu/lists/small/100000.txt

*/

/*

Question #2 - Using much of the work done in question #1, create a function that

accepts a number and returns a bit indicating if the passed in number was prime.

1 for yes, 0 for no. Call your fuction dbo.firstinitialwholelastname_isPrime (dbo.rreed_isPrime)

*/

/*

Question #3 - Create a function that accepts a quantity, unit price

and tax rate. The function should first calculate the total value of

the information passed in - (quantity * unit price) * 1+taxrate.

If there are more than 100 items purchased, give a discount of 8%. If

more than 250 item were purchased, give a 12% discount

Return the final value. Use the Sales.OrderLines records to test

your function. As outlined earlier in class, name your function with

your first initial and full last name (dbo.rreed_CalculateDiscount)

*/

/*

Question #4 - Write a query that exports a JSON string for customerID 200

(Tailspin Toys in Tooele, UT). The query should generate the below string exactly.

Tables that you need to use - Sales.Customers, Sales.CustomerCategories, Application.Citites

Application.StateProvince, and Application.People. I'm using the delivery address

information (including deliveryCityID to join on)

[

{

"CustomerID":200,

"CustomerName":"Tailspin Toys (Tooele, UT)",

"CustomerContact":

{

"PersonID":1399,

"FirstName":"Fanni",

"LastName": "Benko",

"Email":"fanni@tailspintoys.com",

"Address1":"691 Sonkar Avenue",

"Address2":"Suite 264","City":

"Tooele","State":

"Utah",

"Zip":"90100"

},

"CustomerType":"Novelty Shop",

"Website":"http://www.tailspintoys.com/Tooele"

}

]

Explanation / Answer

1

------

#include <stdio.h>
int main()

{
  
int low, high, i, flag;

printf("Enter two numbers(intervals): ");
  
scanf("%d %d", &low, &high);

  
printf("Prime numbers between %d and %d are: ", low, high);

  
while (low < high)
  
{
  
flag = 0;

  
for(i = 2; i <= low/2; ++i)
  
{
  
if(low % i == 0)
  
{
  
flag = 1;
  
break;
  
}
  
}

2

-----

import turtle

def drawSquare(t, sz):
"""Make turtle t draw a square of with side sz."""

for i in range(4):
t.forward(sz)
t.left(90)

wn = turtle.Screen() # Set up the window and its attributes
wn.bgcolor("lightgreen")

alex = turtle.Turtle() # create alex
drawSquare(alex, 50) # Call the function to draw the square passing the actual turtle and the actual side size

wn.exitonclick()

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.