Add six virtual columns to an SQL query that queries a inventory sales file. The query currently structures the data as follows: Invoice Item Number Quantity 1010 1 999.9 2020 2 888.8 3030 3 777.7 4040 4 666.6 Etc. I want it to it structured as follows Invoice 1 2 3 4 1010 999.9 0 0 0 2020 0 888.8 0 0 3030 0 0 777.7 0 4040 0 0 0 666.6 This is only an example of the actual query but it show the principle of what I need don’t I need this today so don’t bid if you can’t do this today. Thanks
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows/ACCESS SQL