I have these tables and I want to show the percantege of customer with deliverd to pending
and the in another sql statment show the number of customer with deliverd to pending
I'm not sure how to calulate these two. I tried the build query on APEX , but it not helping
oh_status VARCHAR2 // status can be pending , deliverd or approved
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.