Databases | SQL | Oracle | MS Access Answers

Using SQL, what query would one use to generate a part list to include the part description, vendor, units on hand, unit price, grouped by a particular warehouse?

Using SQL what query would one use to list each sales rep with their customers' names, address, credit limit and balance?

Perform the following DML operations on the table:
1. Insert values for the table CUSTOMERS with fields – ID, name, age, address and salary and insert records in the table given below:
+----+----------+-----+-----------+----------+
| ID | NAME | AGE | ADDRESS | SALARY |
+----+----------+-----+-----------+----------+
| 1 | Ramesh | 32 | Ahmedabad | 2000.00 |
| 2 | Khilan | 25 | Delhi | 1500.00 |
| 3 | kaushik | 23 | Kota | 2000.00 |
| 4 | Chaitali | 25 | Mumbai | 6500.00 |
| 5 | Hardik | 27 | Bhopal | 8500.00 |
| 6 | Komal | 22 | MP | 4500.00 |
| 7 | Muffy | 24 | Indore | 10000.00 |
+----+----------+-----+-----------+----------+
2. Based on the customer table given above update the salary to 20000 whose salary is less than that.
Based on the customer table given above Fetch ID,
3. Name and Salary fields from the CUSTOMERS table for a customer with name Hardik.

Pleaze send answer of this question.

This is the structure of the table in SQL Azure:

Create Table BCP
(
Id int identity(1,1)
Value int,
Name nvarchar(50),

Constraint [pk_bcp] primMary key clustered([id] asc)
) on [primary]
records I am trying to insert are as follows

100, abc
200, bcd
300, cdf
400, efg
500, fgh
600, ghi
700, hij
800, ijk
900, jkl
I am trying to achieve through command prompt. the command I am using is

C:\Users\Administrator>BCP TestTask.dbo.BCP In C:\Users\Administrator\Desktop\Example\BCP.csv
-S tcp:<servername>.database.windows.net
-U 12345admin@<servername>.database.windows.net
-P Welc@m#123 -E -h 'TABLOCK' -n -k

Consider the relations
EMPLOYEE(emp#, name)
ASSIGNED_TO(project#, emp#)
PROJECT(project#, project_name, chief)
Express the following queries in Relational Algebra
(i) Get details of employee working on both comp354 and comp345 project numbers.
(ii)Find the employee number of employee who do not work on project comp678


pleaz send answer of this question

i have a sql question, was wondering why my query does not work. Here is the question:
A list of the contact details (names, postal address and phone number) of all of the providers who
supplied equipment for more than one activity.

here is the code i entered:
Select phonenumber, line1, city, postcode, providername
from phone, address, provider
where phone.extbusinessid=address.extbusinessid=provider.extbusinessid
and provider.providerid IN(Select providerid, count(providerid)from a_p_equipment
group by providerid having count(providerid)>1)
limit 0,30;