sql 2 update delete insert

[Ulas Gonenc Senturk]

select customers.companyname , shippers.companyname , sum(freight * 0.05) as [Kargo Ücreti]
from orders
inner join customers on customers.customerID = orders.customerID
inner join shippers on shippers.shipperID = orders.shipvia
Group by customers.companyname , shippers.companyname

select employees.firstname + ' ' + employees.lastname , sum(freight * 0.03) as Prim
from employees
inner join orders on orders.employeeID = employees.employeeID
group by employees.firstname + ' ' + employees.lastname
order by prim desc

select categories.categoryname ,sum((products.unitsInstock * unitprice) + (products.unitsonorder * unitprice))
from categories
inner join products on products.categoryID = categories.categoryID
group by categoryname

select suppliers.country as Topt, customers.country as Must , sum([Order Details].unitprice * [Order Details].quantity)
from [Order Details]
inner join products on products.productID = [Order Details].productID
inner join orders on orders.orderID = [Order Details].orderID
inner join suppliers on suppliers.supplierID = products.supplierID
inner join customers on customers.customerID = orders.customerID
group by suppliers.country , customers.country
order by suppliers.country

---------------------------------------------------------------------------------------

insert into Shippers Values ('Aras Kargo', '(5033) 555-4444')
insert into Shippers Values ('Mng Kargo', '(5033) 555-4444')

insert into Employees(Firstname, Lastname, TitleOfCourtesy, Birthdate)
Values        ('Hasan', 'Altıntaş', 'Mr.' , '11.20.1979')

Select * From Shippers

Insert Categories(CategoryName, [Description])
Values('Gardening', 'Useful Gardeners Tools')

select * from categories

------------------------------------------------------------------------------------------------------------------

delete from shippers where ShipperID in (4,5)

update categories set [Description] = 'Gardeners Usefel Stuff' Where CategoryID = 9

update employees set firstname = 'Neriman' , lastname = 'Altıntaş' Where EmployeeID = 1

update products set unitprice = unitprice * 20
 
select * from products