Completed.
ID | Employee Assigned To | Item Name | Per Unit Cost | Quantity | Total Item Cost | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||
2 | Smith | Camcorder | ¤ 1, | 4 | 7 | 5 | 2.0 | 2 | 9 | |||||||||||
3 | Jones | Tablets | ¤ 70.00 | 3.0 | 2 | 10 | ||||||||||||||
Compact Tripods | ¤ | 6 | 1 | 8 | ||||||||||||||||
DSLR Camera | ¤ 950.00 | 1.0 | ||||||||||||||||||
Lavalier Digital Wireless microphone | ¤ | 850.0 | ||||||||||||||||||
¤ 700.00 | 14 | |||||||||||||||||||
O’Connor | Quadcopter Drone | ¤ 1, | 650.0 | 16 | ||||||||||||||||
Perry | Maniken Cart | ¤ 1, | 300.0 | 13 | ||||||||||||||||
Bernard | Wheeled Bucket Case | ¤ 600.00 | 18 | |||||||||||||||||
11 | Mini Coverter | ¤ 300.00 | ||||||||||||||||||
12 | On-Camera Shotgun Microphone | ¤ | 360.0 | |||||||||||||||||
Shotgun Mic with Boom Pole | ¤ 650.00 | |||||||||||||||||||
Rode VideoMic Pro | ¤ | 23 | 460.0 | |||||||||||||||||
15 | Cavision Next Generation Clock Slate Plus | |||||||||||||||||||
Manfrotto Alu Master Air Cushioned Light Stand | ¤ 283.69 | 567.38 | ||||||||||||||||||
17 | Mixer | ¤ | 25 | |||||||||||||||||
Diffusion filter kit | ¤ 85.00 | 170.0 | ||||||||||||||||||
19 | DJI Osmo | ¤ | 9 | 20 | ||||||||||||||||
Condenser Microphone for Smartphones | ¤ 90.00 | 10.0 | 900.0 | |||||||||||||||||
21 | USB Microphone | ¤ 195.00 | 585.0 | |||||||||||||||||
22 | Video Tripod with Fluid Head | ¤ 120.00 | 4.0 | 480.0 | ||||||||||||||||
Micro-Lavalier Omnidirectional Microphone | ¤ 155.00 | 465.0 | ||||||||||||||||||
24 | Wired Intercom System with Four HP-2A Headsets Kit | ¤ 1,500.00 | 1500.0 | |||||||||||||||||
Canon EOS Rebel SL2 – digital camera | ¤ 750.00 | |||||||||||||||||||
26 | Wacom Intuos Creative Pen Small Digitizer | 140.0 |
SELECT DISTINCTROW *
FROM [Lifetime Media Equipment];
SELECT DISTINCTROW *
FROM [Lifetime Media Equipment];
SELECT [Lifetime Media Equipment].[Employee Assigned To], [Lifetime Media Equipment].[Item Name], [Lifetime Media Equipment].[Per Unit Cost], [Lifetime Media Equipment].Quantity
FROM [Lifetime Media Equipment]
WHERE ((([Lifetime Media Equipment].[Employee Assigned To])=”Smith”));